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.
Insert a Break
Create a break with the Main Side Panel:
Breaks Properties
A table break has several customizable properties.
You can set the following properties of a break:
| Property | Description |
|---|---|
| Break header | Displays a header for each part of the table, cross table, or form when a break is inserted. |
| Break footer | 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. |
| Apply sort | 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. |
Watch this video to learn how to add a break: