To define how groups affect the report:
Click the desired query field under Current Group and click Break Options.
The Break Options dialog box is displayed.
If the break object is in the Details section of the report layout, select an option under Print Mode to specify how the column selected as the group break will print in your report.
Print the value only when it changes—Prints a column (or expression) only when the value of the column (or expression) changes. For example, in the Order Details and Analysis report, the report prints a customer name only when it starts printing the customer’s product sales. By defining Name as a group break, the column prints only when its value changes.
Print the value when it changes and at the top of each page—Prints a column (or expression) when it changes and after every page break. For example, if you select this option in the Order Details and Analysis report, a customer name will print not only when it changes, but whenever the report starts a new page.
Always print the value—Always prints the value of the column (or expression).
Never print the value—Never prints the value of the column (or expression). This allows you to use the features of group breaks (group headers, group summaries, line skipping) without actually printing the column or expression value. When a break object is marked “never print”, it has a crosshatched appearance in the SQR Production Reporting Studio layout.
If the break object is the in Group Header section of the report layout, SQR Production Reporting Studio disables the preceding options.
Specify the number of lines to skip when the value of a column (or expression) changes.
Skipping lines when the value of a column (or expression) changes further enhances the effect of group processing.
Enter a value in the Store Previous Value in Variable field to print a column’s value before a break occurs.
For example, assume you group your records by state and place a calculated field in the Group Footer to print the total number of customers in each state. Since the calculated field is in the Group Footer, the total prints only after the value of state changes.
Assume further that you want to print the state name along with the totals for each state. Simply printing the value of state will not work because its value will have changed when the break occurs. If you store the value of state in a variable, however, you can print the value of state along with the total number of customers in each state.
When you store a variable in this field, it appears under Local Variables in the Operations section of the Variable Builder. (For more information on inserting variables, see Adding Variables.)