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.

Watch this video to learn about Breaks.

Add a Break

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.

Multiple Break Headers and Footers

You can adjust the settings in the Setting Breaks dialog box to format the display of breaks for the following properties:

• Display Properties: These determine how the results display in the break.
• Page Layout Properties: These determine how the breaks display in the report page.

Breaks and their properties:

Option	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.

Depending on how you want to work with data and how you want the data to appear, you can switch between two viewing modes.

By default, the document opens in the Quick Display mode. This mode displays tables, reports, and free standing cells in reports and a maximum number of vertical and horizontal records, depending on the settings. It also specifies the minimum page width and height and the amount of padding around the edges of the report. We recommending using the Quick Display mode when you want to focus on analyzing results, add calculations or formulas, or add breaks or sorts to tables to organize results.

The Print Layout mode simulates a printout or generated PDF file, with headers, footers and margins. It's a pagination mode based on standard formats, such as A4, A3, and so on. We recommend using the print layout when you want to fine-tune the formatting of tables, charts, breaks, section and the layout of report pages.

In the Design mode, you can switch between Viewing modes using the Show Print Layout icon in the toolbar. If you're in Reading mode, the icon is in the Vanishing toolbar at the bottom of the report canvas. When off, the report is in Quick Display mode. When on, the report is displayed in Print Layout.