Groups |
The Groups tab enables you to specify a subsection, or level of control, in a query or report. To access this tab, you must be authorized to use the Query/Report Generator.
Groups make it possible to obtain subtotals for all rows that contain the same value in a specific column and to start a new page when the value in a specific column changes. From the Groups tab, you can define subsections in the query or report, define new groups, or clear all previously defined groups.
Note: Quick-view queries do not process groups; use the Manage tab.
In addition to the Query/Report Generator, you can use FA Web Modules or any other reporting tool sold separately (such as Microsoft Access) that can attach to the database. See the related documentation for these products.
The top section of this screen displays a list of existing queries or reports. If you select a query or report, the groups it contains display in the right-side column in the bottom section of the tab.
Each group you define is associated with a column you select. Whenever the value in that column changes, a group break is generated, the group totals that you define (see the Layout tab) are printed, and a new group is started.
Each group that you define is numbered, starting with 1. You can define any number of groups for a single query or report.
All summary items that you define for the query or report (see the Layout tab) are automatically available for each group so that you can easily create subtotals.
To include groups in the query or report, see How to Create Groups.
_______________
See Also