Format Data dialog: Breaks tab

Use this tab to change the group sorting style of the currently selected worksheet item (for more information about group sorting, see "What is group sorting?"). For example, if you create a group sort on a worksheet item called Region, you might want to insert a blank row after each region to make the worksheet more readable.

Note: These options are grayed out when the selected item is not group sorted. To specify breaks for the selected item, first create a group sort on the item (for more information, see "How to sort data on a table worksheet"). You cannot apply a group sort to an item on a crosstab worksheet.

For more information, see:

"About Discoverer worksheet types"

"What is group sorting?"

Insert

Line

Use this check box to enable the adjacent fields, which enable you to separate data rows on a worksheet with a horizontal line. The fields enable you to specify a line thickness and line color. For example, if worksheet data is grouped by region, you might want to display a thick blue line between each region.

Blank Row

Use this check box to enable the adjacent field, which enables you to separate data rows on a worksheet with one or more blank lines. The adjacent field enables you to specify the number of blanks lines. For example, if worksheet data is grouped by region, you might want to display two blank lines between each region.

Page Break

Use this check box to separate data rows on a worksheet by displaying each group on a new page. For example, if worksheet data is grouped by region, you might want to display each region on a separate page in the worksheet.