Worksheet Properties dialog: Sheet/Crosstab Format tab

Use this tab to specify how the current worksheet is displayed. Use this dialog to:

display or hide headings, gridlines and row numbers
define crosstab style and gridline color
define how to display null values
show drill links as icons

For more information, see:

Table headers (options displayed for tabular worksheets)

Show column headings

Use this check box to display or hide column headings on the current worksheet. You might want to hide column headings, for example if they are not required on a worksheet. Discoverer displays column headings by default.

Show row numbers

Use this check box to display or hide row numbers on the current worksheet. You might want to show row numbers, for example to enable users to use the row numbers to locate a specific worksheet row. Discoverer displays row numbers by default.

Crosstab headers (options displayed for crosstab worksheets)

Show item labels

Use this check box to display or hide the crosstab item labels on the current worksheet (e.g. Region). If item labels have been defined, they are displayed on the crosstab vertical or side axis.

Show heading gridlines

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

3D heading gridlines

Use this check box to display the crosstab heading gridlines in 3D style. This check box is only enabled when the Show heading gridlines check box is selected.

Crosstab style

Use this drop down list to select a value to configure the side (left) axis on a crosstab as follows:

Inline

Choose this option to display the first child row, on the same row as its parent. For example, on a worksheet that shows Years and Months, January (the first child row) appears on the same row as the year 2001 (the parent row).
Outline

Choose this option to display the first child row on the row below its parent. For example, on a worksheet that shows Years and Months, January (the first child row) appears on the row below the year 2001 (the parent row).

Cell or data body gridlines

Show vertical gridlines

Use this check box to display or hide the vertical gridlines (in the data cells).

Show horizontal gridlines

Use this check box to display or hide the horizontal gridlines (in the data cells).

Gridline color

Use this button to change the color of the gridlines that are displayed in the data cells.

Content

Show null values as

Use this drop down list to specify how Discoverer displays null (or empty) values. For example, if you typed the words No information available in this field, Discoverer will display this text when there is no data for a cell. Discoverer displays a blank cell by default.

Show drill links as

Use this check box list to specify that Discoverer displays drill links as icons. Alternatively, you could clear this check box to specify that Discoverer displays drill links as hypertext links.

Example

This area shows you how the worksheet will look, with the options you have set.