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

Chapter 15. Preparing Advanced Reports > Reducing the Length of Reports

Reducing the Length of Reports

A report's properties or controls don't limit the number of rows of detail data that a report presents. One way of minimizing detail data is to write a TopN or TopNPercent query using Jet SQL. (Search the online help for the TopValues property to learn more about TopN and TopNPercent queries.) All rows of a table or query appear somewhere in the report's Detail section, if the report includes a Detail section with at least one control. To include only a selected range of dates in a report, for example, you must base the report on a query with the criteria necessary to select the Detail records or apply a filter to the report. If the user is to select the range of records to include in the report, use a parameter query as the report's data source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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