Previous
Previous |
This page enables you to change some settings related to the current worksheet.
Display Options
Title
Use this check box to display the title in the worksheet.
Table/Crosstab
Use this check box to display the table or crosstab data in the worksheet (displayed with Oracle Applications or relational database connections).
Use this option to display the crosstab data (displayed with worksheets created using OLAP connections).
Graph
Use this check box to display the graph in the worksheet (displayed with Oracle Applications or relational database connections).
Use this option to display the graph in the worksheet (displayed with worksheets created using OLAP connections).
Both
Use this option to display the graph and the crosstab data in the worksheet (only displayed with OLAP connections).
Text Area
Use this check box to display the text area in the worksheet.
Sheet Options
Show axis labels
Use this check box to display crosstab header labels in the worksheet.
Show null values as
Where no data is returned for a field in a worksheet you can define here how the data is displayed. For example, if you enter 'Zero' in this field, worksheets display the word 'Zero' where no data is returned.
Show values that cannot be aggregated as:
When a worksheet tries to aggregate an item that cannot be aggregated (for example Rank), you can define here how the data is displayed. For example, if you enter 'N/A' in this field, worksheets display the text 'N/A' where the data cannot be aggregated.