Options dialog: Sheet Format tab (on a crosstab worksheet)

Use this tab to configure the way that the current worksheet is displayed. Use this dialog to:

Display or hide the worksheet title or gridlines
Display or hide row numbers
Define the number of rows displayed on each page of the worksheet

For more information, see:

Show

Title

Use this check box to display or hide the worksheet title. The title, if one has been defined, appears at the top of the worksheet.

Horizontal and vertical cell gridlines

Use this check box to display or hide gridlines on the worksheet.

Null values as

Use this pull down list to specify how Discoverer displays null (or empty) values.

Values that cannot be aggregated as

Use this pull down list to specify how Discoverer displays values that cannot be aggregated, typically that are already aggregates.

Style

Use these radio buttons to configure the side (left) axis on a crosstab.

Inline

Use this check box to display the first row of a group on the same row as the parent row. For example, on a worksheet with Years and Months, January appears on the same line as the 2001.

Outline

Use this check box to display the first row of a group one row below the row showing the parent row. For example, on a worksheet with Years and Months, January appears on the row below 2001.

Screen page layout

Rows per screen page

Use this field to specify how many rows are displayed on a worksheet at one time. To change the default number, enter a new number or use the up and down arrows to increase or decrease the number.

Example

This areas shows you how the worksheet will look, according to configuration options you set.