Pivot tables from visual basic 6

Hi,

I need to generate pivot tables for various queries which may involve different tables. I want to be able to bring up the pivot table view along with the Pivot Table Field List for a resulting set using visual basic 6. The resulting set is generated by calling a stored procedure from visual basic.

Can you refere me to some websites or code.


Thanks
skyrise11Asked:
Who is Participating?
 
PashaModConnect With a Mentor Commented:
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0
 
jdlambert1Commented:
I don't understand what you want. Do you want to create a stored procedure that creates columns from row-data? If so, please list the structures of your tables, including primary and foreign keys, provide sample data for each table, and finally, a sample of what you want your results to look like.
0
 
skyrise11Author Commented:
OK,

I want to be able to bring up the pivot table view for a resulting table using visual basic instead of having to manually go to the "View" menu and click on Pivot Table View. The parameters to the stored procedures that generate the resultsets are passed using visual basic.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
imrancsCommented:
which DB you are using?
0
 
skyrise11Author Commented:
I'm using Microsoft Access sp3.
0
 
skyrise11Author Commented:
I wanted to bring up Pivot Table reports from VBA. But I got it.
You simply set the default view of a form to PivotTable, and open the form from visual basic..
0
 
jdlambert1Commented:
No problem!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.