Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Pivot tables from visual basic 6

Posted on 2004-09-06
8
Medium Priority
?
313 Views
Last Modified: 2013-11-25
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
0
Comment
Question by:skyrise11
7 Comments
 
LVL 15

Expert Comment

by:jdlambert1
ID: 11992931
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
 

Author Comment

by:skyrise11
ID: 11993109
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
 
LVL 10

Expert Comment

by:imrancs
ID: 11994141
which DB you are using?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:skyrise11
ID: 12001920
I'm using Microsoft Access sp3.
0
 

Author Comment

by:skyrise11
ID: 12049643
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
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12056195
No problem!
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12094588
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question