Creating Groups

Report groups enable you to group data by subcategory and optionally produce totals by group.

A group is a simple concept; for example, if you want to print a report showing customer sales, you could group on customer name and therefore show a sales item list for each customer. The following image shows a section of a report that groups customer sales by customer.

When you create a group, the JADE Report Writer Designer application automatically creates a group header and group footer section. In the above example, the customer name is in the group header section and the total line is in the group footer.

You can create groups at other levels for the same report. In the above example, you could provide another level of grouping based on location (such as retail areas). This group would be at a higher level and would typically provide totals (summaries) by location. Your report would then have three levels of summary: customer totals, area totals, and a grand total.

You can use profiles to change group detail. Profiles enable you to run different editions of your report simply by choosing a profile against which to run it.

Within your profiles, you can select alternative fields on which to group data. Using the above example, if one profile has its grouping based on customer, a second profile could have grouping based on product. When you run the report, you select the profile with which the report runs.

For details about creating report profiles, see "Creating or Maintaining Profiles" under "Using Administrative Functions", earlier in this chapter.

Creating, updating, and using groups are described in the following subsections.

• Creating a New Group

• Updating an Existing Group

• Using Groups Example