By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Dynamic Crosstab Report IN VISUAL BASIC

P: n/a
i
i am praful pathak,porbandar
i want to develop my own cross tab report in visual basic 6 i know what
developed query from ms access but how to coded in visual basic in
designing time and how to construct it
plz solve this problem

query from ms access

TRANSFORM Sum(Temp.SumOfS_Qty) AS SumOfSumOfS_Qty
SELECT Temp.S_Name, Temp.Comp_Name, Temp.s_dt, Temp.bill_no
FROM Temp
GROUP BY Temp.S_Name, Temp.Comp_Name, Temp.s_dt, Temp.bill_no
PIVOT Temp.Itm_Name;

than out put these :-

S_Name Comp_Name s_dt bill_no BISCUIT K_K_ 10 K_K_ 5 WEFARE
Manishbhai Abc 20/09/2006 4 250
Manishbhai CDa 01/10/2006 5 500
Rambhai Abc 20/09/2006 1 4 2
Rambhai Abc 20/09/2006 2 500
Rambhai Abc 10/10/2006 6 1500
Rambhai CDa 20/09/2006 3 250 250
so now i want to arrange that in visual basic with multipale column

if u solve my probleme plz send my mail add
a lots of thanks

pr********@yahoo.com

From
Praful Pathak,Porbandar

*** Sent via Developersdex http://www.developersdex.com ***
Oct 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I presume you are using ActiveX Data Objects (ADO) code to access the Jet
database (as is normal with VB6). Is that so? As I rarely use ADO, because
I prefer the DAO that is native to Jet databases, I will ask that someone
else respond to you.

And, you would likely have a better chance of getting a good answer if you
asked in a newsgroup devoted to VB6 use of databases. A USENET newsgroup
that I have found useful in the past is comp.lang.basic.visual.misc and
there are a number of Visual Basic newsgroups available from the (free)
newsreader news.microsoft.com, some, I think, specifically devoted to
databases.

Larry Linson
Microsoft Access MVP
"praful pathak" <pr********@yahoo.comwrote in message
news:45*********************@news.qwest.net...
>i
i am praful pathak,porbandar
i want to develop my own cross tab report in visual basic 6 i know what
developed query from ms access but how to coded in visual basic in
designing time and how to construct it
plz solve this problem

query from ms access

TRANSFORM Sum(Temp.SumOfS_Qty) AS SumOfSumOfS_Qty
SELECT Temp.S_Name, Temp.Comp_Name, Temp.s_dt, Temp.bill_no
FROM Temp
GROUP BY Temp.S_Name, Temp.Comp_Name, Temp.s_dt, Temp.bill_no
PIVOT Temp.Itm_Name;

than out put these :-

S_Name Comp_Name s_dt bill_no BISCUIT K_K_ 10 K_K_ 5 WEFARE
Manishbhai Abc 20/09/2006 4 250
Manishbhai CDa 01/10/2006 5 500
Rambhai Abc 20/09/2006 1 4 2
Rambhai Abc 20/09/2006 2 500
Rambhai Abc 10/10/2006 6 1500
Rambhai CDa 20/09/2006 3 250 250
so now i want to arrange that in visual basic with multipale column

if u solve my probleme plz send my mail add
a lots of thanks

pr********@yahoo.com

From
Praful Pathak,Porbandar

*** Sent via Developersdex http://www.developersdex.com ***

Oct 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.