Step 3 of 6 - Select Group Defaults

Reports > Report Writer Reports > Reports > Writing a Report

Step 3 of 6 - Select Group Defaults

This screen is only shown if you have selected at least one grouping field in the previous step. Here you can designate whether you want the values in each group sorted in ascending or descending order, and if you want to show a header and/or footer.

• Sort Order: The values of the fields you have selected for grouping can be sorted in Ascending or Descending Order.

• Report Show Header?: If selected, this option will print a header for each value contained in the group. If the group value changes, a new header will be displayed.

NOTE: An empty string or NULL value is also a value. If you do not want these values included in the report, they must be filtered in the query by specifying the Field IS NOT BLANK.

• Report Show Footer?: If selected, this option will print a footer for each value contained in the group. If the group value changes, a new footer will be displayed. The footer is where any field totals are displayed. So if you select at least one field for grouping, the "Show Footer?" option must be selected in order for totals to be displayed by group in the report.

NOTE: All subtotal values are shown in the group footer as well as the report footer. If you have selected a subtotal for any of your data, the group footer must be selected in order for the totals to be displayed.

Once you have selected Sort Order and Header/Footer options that should apply, click “Next” to continue.