Applying Breaks to a Table

Objectives

After completing this lesson, you will be able to:

  • Apply and format breaks

Breaks

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.

The following are the main advantages of using 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.

Value-Based Breaks

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.

Same Level Breaks

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.

Sorts and Breaks

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.

Break Headers and Footers

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

See the following video to learn more about the Breaks Properties.

Breaks and their Properties:

BreaksProperties
Break headerDisplays a header for each part of the table, cross table, or form when a break is inserted.
Break footerAdds 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 sortApplies the default sort order to the values in the break
Value based breakThe break footer and header are displayed only for the values you've selected.
Duplicate values: Display allDisplays all values in the break, even when there are duplicates
Duplicate values: Display firstDisplays only the first value when there are duplicates
Duplicate values: MergeMerges cells containing duplicate values and displays a single value over the merged cells
Duplicate values: Repeat first on new pageThis 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 pageThis displays each part of the table or form created by a break on a new page.
Avoid page breaks in blocksWhere 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 pageThis repeats the header at the top of the table on every new page when a table displays on more than one page.

Multiple Breaks Prioritization

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.

Apply Breaks

Log in to track your progress & complete quizzes