Creating Summary Columns

A summary column is a calculated field that the default layout generates in the Group Summary section of a report.

For example, assume you create a report that displays information about the orders placed by each of your customers. In this case, you could create summary columns that calculate and print the total number of orders placed by each customer and the total cost of each customer’s orders.

To create a summary column to appear in the default layout:

Double-click under the Summary heading for the desired column.
Select the column, click Edit to access the Layout Settings dialog box, and select Create summary columns in group footer.

When you create a summary column for a text column, SQR Production Reporting Studio counts the items in the column. For example, you could count the number of customers in a report.

When you create a summary column for a numeric column, SQR Production Reporting Studio sums up the items in the column. For example, you could calculate the total cost of the orders placed by a customer.

You cannot create a summary column for a date column.

Note:

Since SQR Production Reporting Studio places summary columns in the Group Summary section of a report, you must create group breaks for the summary columns to appear. See Creating Group Breaks.

Note:

Click Save as Default to use the default settings you define in each new report you create. If you change the default settings and don't save them, SQR Production Reporting Studio only applies the settings to your current report.