Breaks allow you to structure the data in a table into groups and to make the data easier to view and interpret. You can apply breaks on the data and values that you select.
When you apply a break, Web Intelligence separates all the data for each unique value of the selected variable. It inserts a blank row or column after each value, which allows you to easily insert subtotals for the data group.
The following are the main advantages of using breaks:
- You can efficiently organize the representation of data.
- You can display subtotals.
A table break has several customizable properties.
You can set the following properties of a break:
Displays a header for each part of the table, cross table, or form when a break is inserted.
Adds a footer after the last row for a table or the last column for a cross table when a break is inserted. When you apply a calculation to the data, the result displays in the footer.
Applies the default sort order to the values in the break.
|Value based break
The break footer and header are displayed only for the values you've selected.
|Duplicate values: Display all
Displays all values in the break, even when there are duplicates.
|Duplicate values: Display first
Displays only the first value when there are duplicates.
|Duplicate values: Merge
Merges cells containing duplicate values and displays a single value over the merged cells.
|Duplicate values: Repeat first on new page
This displays the first value in a group of duplicate values at the beginning of the break and on each new page.
|Start on a new page
This displays each part of the table or form created by a break on a new page.
|Avoid page breaks in blocks
Where possible, this keeps each break section on the same page. This option does not apply to blocks larger than one page.
|Repeat header on every page
This repeats the header at the top of the table on every new page when a table displays on more than one page.