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

Chapter 11. CREATING POWERFUL REPORTS > USING DYNAMIC COLUMNS TO CREATE A REPOR...

USING DYNAMIC COLUMNS TO CREATE A REPORT OFF A CROSSTAB QUERY

One of the more powerful report tasks is to create a report that can dynamically change, depending on the circumstances at the time the report is run. An example of this—and one that will be used for the rest of this discussion—is a production report that tracks the sales for customers over a set period of months.

This report, DynamicColumnsExample, is based off a crosstab query named qxtbDynamicColumnExample. The report is opened in Print Preview from the form named DynamicColumnsExamples, which is built the same way as the other sample forms in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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