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

Chapter 7. What Every Developer Needs to... > Working with Sorting and Grouping

Working with Sorting and Grouping

As opposed to sorting within forms, sorting the data within a report isn't determined by the underlying query. In fact, the underlying query affects the report's sort order only when no sort order has been specified for the report. Any sort order specified in the query is completely overwritten by the report's sort order, which is determined by the report's Sorting and Grouping window. (See Figure 7.24.) The sorting and grouping of the report is affected by what options you select when you run a Report Wizard. The Sorting and Grouping window can then be used to add, remove, or modify sorting and grouping options for the report. Sorting simply affects the order of the records on the report. Grouping adds Group Headers and Footers to the report.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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