Use the Layout Settings dialog box to define whether to include a column in the default report layout, and whether to create summary columns to appear in the summary section of your report. To select an option, click the check box next to the option.
Including Columns in the Default Report Layout
When you add a database column to your query, SQR Production Reporting Studio automatically includes the column in the default report layout.
Excluding a column does not prevent you from adding it to the layout at a later time – it simply excludes the column from the default layout.
Summary columns are calculated fields generated by the default layout 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 would 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, select Create summary columns in group footer.
When you create a summary column for a text column, the summary column counts the number of 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, the summary column 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.
Since SQR Production Reporting Studio places summary columns in the Group Summary section of a report, you must create group breaks in order for the summary columns to appear (see Creating Group Breaks).