Use this tab to specify how all new worksheets are displayed. For example, use this dialog to:
display or hide column headings, gridlines and row numbers
define column width, crosstab style and gridline color
display or hide the worksheet title, text area
define how to display null values
show drill links as icons
For more information, see:
Use this check box to display or hide column headings on worksheets. You might want to hide column headings if they are not required on a worksheet. Discoverer displays column headings by default.
Use this check box to display or hide row numbers on worksheets. You might want to show row numbers to enable users to use the row numbers to locate a specific worksheet row.
Use this drop down list to specify the column width. The available options are:
Use default width
Select this option if you want the column to be the same width as the column heading.
Use auto width
Select this option if you want the column to be the width of the column heading or the widest data cell (whichever is the wider).
Use this check box to display or hide the crosstab item labels (for example, Region). If item labels have been defined, they are displayed on the crosstab vertical or side axis.
Use this check box to display or hide crosstab vertical axis 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.
Use this drop down list to control the appearance of the side 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).
Use this check box to display or hide the vertical gridlines in the data body.
Use this check box to display or hide the horizontal gridlines (that is, in the data body).
Use this button to change the color of the gridlines that are displayed (that is, in the data body).
Use this check box to display or hide the worksheet title. When you select this check box Discoverer displays a title area at the top of each new worksheet.
Hint: You can also specify whether Discoverer displays or hides the title of the current worksheet (for more information, see "How to display or hide worksheet titles or text").
Use this check box to display or hide the text area. If a text area has been defined, it appears at the bottom of the worksheet.
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 displays this text when there is no data for a cell. Discoverer displays a blank cell by default.
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.
This area of the dialog indicates how the worksheet looks, with the options you specified.