Applying Breaks to a Table

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Apply and format break


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.

Breaks properties

A table break has several customizable properties.

You can set the following properties of a break:

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.

Log in to track your progress & complete quizzes