On the Organize Records by Category panel, you select the break fields that you want to categorize your report by. For example, if you have sales data that you want to group by region, you would choose the Region field.
In Report categories, the order of the break fields determines the hierarchy, or nesting, of the categories. So, if you want to group sales data by region and then by city, you would choose the Region field first, and then the City field.
|
|
|
|
|
In Report fields, double-click the fields you want, in the order you want them used in the hierarchy. (Or select one or more fields, then click Move.)
Note Only the fields you chose in the previous panel are available. If you need to add a field, click Back. The assistant saves your choices in this and all preceding panels.
|
|
|
In the Report categories list, select the checkboxes of the break fields you want to display in the body of the report.
|
|
|
In the Report categories list, clear the checkboxes next to the fields that you want to prevent from appearing in the body of the report.
Note Data in the report will be grouped by all fields you include in the Report categories list, but non-selected fields will not appear in the report.
|
|
|
In Report categories, double-click the field you want to remove. (Or select one or more fields, then click Clear.)
|
|
|
In Report categories, drag the double-arrow next to the field name to a new position.
|
As you change the number of break fields in Report categories, the image on the right changes to reflect your choices. The assistant displays the selected break fields in shades of blue to help you judge the hierarchy that you want.
FileMaker Pro automatically sorts your report by the fields you choose for report categories. (They are pre-selected in the Sort Records panel that you see next.)