Break Options

Defines how groups affect the printed report.

Option	Description
Print Mode	If the break object is in the Details section of the report layout, select an option to specify how the column selected as the group break will appear in your printed report. (If the break object is in any other section of the layout, SQR Production Reporting Studio disables the print mode options.) Print the value only when it changes—Prints a column (or expression) only when the value of the column (or expression) changes. For example, you may want to print a customer number and name only when you start a list of invoices for the customer. By defining the cust_num and name columns as groups, the columns print only when their value changes. Print the value when it changes and at the top of each new page—Prints a column (or expression) when it changes and after every page break. For example, if you have a column called state, the value of state will be printed 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 is useful when you want to use the features of group breaks (group headers, group footers, line skipping, etc.) without actually generating output for the column or expression value. When a break object is marked “never print”, it has a crosshatched appearance in the Production Reporting layout.
Other Options	Lines to skip when value changes—Enter the number of lines to skip when the value of a column (or expression) changes. Inserting one or more lines between groups can further enhance the visual effect of group processing. Store previous value in variable—Use this field to enter the previous break value of a column (or expression) and store it in a string variable. This allows you to print the 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 object is in the Group Footer, the totals will print 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.

Option

Description

Print Mode

If the break object is in the Details section of the report layout, select an option to specify how the column selected as the group break will appear in your printed report. (If the break object is in any other section of the layout, SQR Production Reporting Studio disables the print mode options.)

Print the value only when it changes—Prints a column (or expression) only when the value of the column (or expression) changes. For example, you may want to print a customer number and name only when you start a list of invoices for the customer. By defining the cust_num and name columns as groups, the columns print only when their value changes.
Print the value when it changes and at the top of each new page—Prints a column (or expression) when it changes and after every page break. For example, if you have a column called state, the value of state will be printed 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 is useful when you want to use the features of group breaks (group headers, group footers, line skipping, etc.) without actually generating output for the column or expression value. When a break object is marked “never print”, it has a crosshatched appearance in the Production Reporting layout.

Other Options

Lines to skip when value changes—Enter the number of lines to skip when the value of a column (or expression) changes. Inserting one or more lines between groups can further enhance the visual effect of group processing.
Store previous value in variable—Use this field to enter the previous break value of a column (or expression) and store it in a string variable. This allows you to print the 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 object is in the Group Footer, the totals will print 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.