• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Adding Graphs, PivotCharts, ... > Working with PivotChart Forms

Working with PivotChart Forms

Microsoft promotes Office XP PivotCharts as a substitute for MSGraph OLE Objects for a good (marketing) reason: MSGraph requires a crosstab query or equivalent and, as mentioned earlier, SQL Server's T-SQL doesn't support crosstab queries directly. If you want to add graphs or charts to ADP, PivotCharts are the least-effort answer. The same is true if you anticipate upsizing your Jet databases to SQL Server and upgrading conventional Access objects to ADP forms and reports.

The sections that follow describe how to use PivotCharts to emulate the unlinked and linked MSGraph objects you created in the preceding sections of this chapter. The example PivotCharts use the qry1997SalesChart query, because the Jet SQL and T-SQL versions of the query are identical. The PivotTable created from the query acts as the data source for the PivotChart by handling the data restructuring ordinarily accomplished by Jet SQL PIVOT...TRANSFORM statements.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint