Report Content

If you want a query or report that lists all the data in the database for the tables and data items you select, you do not have to specify report content items. If you want to define other items to include on the query or report, use the User-defined Items tab.

To control the content of a query or report, you specify rules that determine whether to include a row (or record) from a table. These rules are called restrictions. You can specify simple or complex restrictions on the Restrictions tab.

To control the order in which data appear in the query or report, you specify sort rules on the Sorts tab. You can define any sort order you want, using any data items in any selected table, as well as special items you define.

There is no limit to the number of data items or special items that you can include in the sort order definition. If you define a sort order that does not correspond to one of the pre-defined indexes for the first table you select, however, it takes longer to sort the data.