General Properties

General properties affect the entire table. Use general properties to edit the following:

Table 5-1 Table - General Properties

Property Name	Descriptions
Name	Edit the table name. A best practice is to name your tables with a meaningful name for easier identification of multiple tables in a report.
Title	Specify a table title, which can include text and text functions, to include at the top of the table output, which can span across column headers. The table title can also have font, border and shading formatting applied, see the related formatting topics. To add multiple lines to the table title, use the Alt+Enter keys (Option+Enter on the Mac).
Data Source	Change the data source for the table.
Column Width / Row Height	Set the default column width and row height.
Row Banding	Apply shading to alternate rows in a table. You can select the default shading color. Any columns or rows with existing shading in the table are not affected by row banding.
Drill Through to Source	To enable Drill Through to Source, which provides the ability to drill through to a source system (if defined at the source schema), for the entire table, set Drill Through to Source to Show. If set to Hide, individual cells can still be enabled in Cell Properties.
Display Options
Member Labels	Change how the row and column headings are displayed. For example, you can display member names, aliases, or both. Note: These settings can be overridden at the column or row level.
Alias Table Name	By default, tables use the alias table that was selected by the end user while previewing the report. However, you can select a different alias table at the table level. Use Alias Table Name to set an alias table for the table.
Text Options
Error	Set the text replacement options for cells with zero results from a formula.
Text character width	The property allows you to choose between more and less conservative sizing of text in a table text cell. The property can have a value of Large, Medium, or Small. By default, the property is set to Large.
Formats
Date and Time Formats	The date and time format for table cells that contain dates is derived from the User Preferences date/time format setting. Use Date or Time Formats in table properties to override the date/time formats with a format specific to the table. This date/time format will apply to any date/time cell values in the table. If you do not specify a date or time format for the table, the format from User Preferences is used.
Cell Padding Horizontal Vertical	Specify the number of pixels used to pad cells vertically and horizontally. The default number is 5 pixels. Migrated Financial Reporting (which does not support cell padding) reports have this value set to zero.
Grouping Group Page Break No Page Breaks in Group	Defines how page breaks are handled when previewing the report in PDF format.
Conditional Expression Use scaled/rounded value	To specify whether conditional formatting and suppression, as well as basic (table, column or row) suppression, use scaled or unscaled raw data values within a condition, use the table property Use scaled/rounded value. The default is True, which means that the formatted and scaled data values are used within the condition. For example, if a cell with a data value of 125,016,551 is scaled to thousands and displayed as 125,016, the 125,016 value will be used within the condition. If the property is set to False, the underlying and unscaled data value will be used within the condition. This setting applies to all conditional formatting and suppression for the table.