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

Hour 17. Power Report Techniques > Working with Sorting and Grouping

Working with Sorting and Grouping

Unlike sorting data within a form, sorting data within a report isn't determined by the underlying query. In fact, the underlying query affects the report's sort order only when you have not specified a sort order for the report. Any sort order specified in the query is completely overwritten by the report's sort order, which is determined in the report's Sorting and Grouping window (see Figure 17.23). The sorting and grouping of a report is affected by what options you select when you run the Report Wizard. You can use the Sorting and Grouping window to add, remove, or modify sorting and grouping options for a report. Sorting simply affects the order of the records in the report. Grouping adds group headers and footers to the report.

Figure 17.23. The Sorting and Grouping window, showing grouping by Country, City, and OrderID and sorting by product name.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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