Column definition
A column definition is a report component, also called a building block, which defines the contents of columns in a report. Like row definitions, a basic column definition can be used in multiple reports.
This topic contains the following sections:
Create and modify a column definition
Contents of a column definition
Create and modify a column definition
A column definition can contain 2 to 255 columns.
Create a column definition
In Report Designer, click Column Definitions.
On the File menu, click New, and then select Column Definition.
Add the information that is defined in Contents of a column definition.
Open a column definition
Open Report Designer. In the navigation pane, click Column Definitions.
Double-click a column definition to open it.
Add a column to a column definition
In Report Designer, click Column Definitions, and then open the column definition to modify.
Select a column where a new column should be inserted.
On the Edit menu, click Insert Column. The new column appears to the left of the column that you selected.
Delete a column from a column definition
In Report Designer, click Column Definitions, and then open the column definition to modify.
Select the column to delete.
On the Edit menu, click Delete Column.
Contents of a column definition
A column definition includes the following information:
Column of the row definition descriptions.
Amount columns that display data from the financial data, an Excel spreadsheet, or calculations on other data in the column definition.
Formatting columns.
Attribute columns.
This information appears in the following areas in the column definition:
The headers area of the column definition contains the heading text and formatting that appears in the report. A header can apply to a single column of data, spread across multiple columns, or apply to columns on a conditional basis. For more information about column headers, see “Create and manage column headers” section in Format columns. The column definition can include as many column header rows as you need.
Note
Column headers apply to each column of data in the report. Report headers apply to the whole report. Define report headers on the Headers and Footers tab of the report definition.
Column detail rows are the rows under the header rows in the column definition. Column detail rows define the information to include in the report. The following table lists and describes the column detail rows.
Column detail row name
Description
For more information
Column Type
This is a required component. Specifies the type of data in this column.
“Column types” section in Specify a column type in a column definition
Book Code/Attribute Category
Specifies financial data information for FD and ATTR column types.
“Financial Dimensions column” section in Specify a column type in a column definition
Fiscal Year
Period
Periods Covered
Specify financial data information for FD column types.
“Financial Dimensions column” section in Specify a column type in a column definition
Formula
Specifies a calculation formula for CALC column types.
“Calculation column in a column definition” section in Specify a column type in a column definition
Column Width
Extra Spaces Before Column
Format Override
Print Control
Specify special format options.
“Add special formatting options” section in Format columns
Column Restrictions
Restricts data.
“Column Restrictions cell” section in Column restrictions in a column definition
Reporting Unit
Restricts the column to show data for the specified reporting unit only.
Currency Display
Currency Filter
Format currency.
XBRL Currency
XBRL Dimension
Specifies XBRL currency and dimensional data. Dimensions not defined in the column definition must be defined in the reporting tree definition.
Dimension Filter
Specifies a filter to limit data to certain financial data reporting units.
“Financial Dimensions column” section in Specify a column type in a column definition
Attribute Filter
Specifies a filter to limit the financial data.
“Financial Dimensions column” section in Specify a column type in a column definition
Start Date
End Date
Restrict the financial data to specific dates.
Justification
Left, center, or right justifies the description text that is specified in the row definition.