Applying Breaks to a Table

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.

See the following video to learn more about Breaks.

• You can efficiently organize the representation of data.
• You can display subtotals.

When you insert a break on a dimension, the values for the dimension are automatically sorted in ascending order.

For numeric values, the lowest value is displayed in the first row of the table and the highest value displays in the last row.

For alphabetical character values, the values are sorted in alphabetical order, from first row to last.

You can create breaks based on values that you have purposely selected.

When creating value-based breaks, the headers and footers are only displayed for the values that you have selected.

You can create breaks at the same level in the a table using multiple objects.

When creating same level breaks, the objects in the break share the same footer, and are displayed in the same row in the table.

When you insert a break on a dimension, Web Intelligence automatically sorts the values for the dimension in ascending order.

For numeric values, the lowest value appears in the first row of the table, the highest in the last row.

For alphabetical characters, the values appear in alphabetical order from top to bottom. You can change this sort order at any time.

Report designers frequently use breaks to structure table data into smaller groups in order to create subtotals. When you apply a break to a table, the break footer displays as an additional row at the bottom of the table and displays the subtotal data clearly. However, every time that a break is placed on a table, a header is created.

When you know how to control the display of headers and footers, you can use them to present your data clearly. For example, you can create a report that shows Year, Quarter, Month Name, and Sales revenue, and insert a break on both Year and Quarter, but it only display footers for the break on Quarter. The Quarter footer can contain the sum for the quarterly sales revenue.

You can create a report with the same objects, insert a break on both Year and Quarter, and display footers for both Year and Quarter. Then, you can display both the yearly and quarterly sales revenues in the appropriate footer.

You can also use the Manage Breaks dialog box to prioritize multiple breaks.

In a document with multiple breaks, you can change the default order so that one break is displayed at a higher priority than the others.