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.
A column definition can contain 2 to 255 columns.
Create a column definition
-
In Report Designer, click Column Definitions.
-
On the Filemenu, click New, and then select Column Definition.
-
Add the information that is defined in the Contents of a column definition section later in this topic.
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 Editmenu, 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 Editmenu, click Delete Column.
Contents of a column definition
A column definition includes the following information:
-
A column that displays the descriptions from the row definition.
-
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 two sections 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 column headers . 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 Footerstab 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
Column Type
Specifies the type of data in this column. For more information, see Specify a column type in a column definition . This is a required component.
Book Code/Attribute Category
Specifies financial data information for FDand ATTRcolumn types. For more information, see Financial Dimensions column .
Accounting Year
Period
Periods Covered
Specify financial data information for FDcolumn types. For more information, see Financial Dimensions column .
Formula
Specifies a calculation formula for CALCcolumn types. For more information, see Calculation column in a column definition .
Column Width
Extra Spaces Before Column
Format/Currency Override
Print Control
Specify special format options. For more information, see Add special formatting options or Adjust columns while designing reports .
Column Restrictions
Restricts data. For more information, see Add a column restriction .
Reporting Unit
Restricts the column to show data for the specified reporting unit only. For more information, see Build a reporting tree definition .
Currency Source
Currency Filter
Format currency. For more information, see Format a multiple currency report in a column definition .
XBRL Currency
XBRL Dimension
Specifies XBRL currency and dimensional data. For more information about the XBRL Dimensions dialogue box, see Link to XBRL taxonomies . 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. For more information, see Apply a dimension filter in a column definition .
Attribute Filter
Specifies a filter to limit the financial data. For more information, see Apply an attribute filter in a column definition .
Start Date
End Date
Restrict the financial data to specific dates. For more information, see Restrict a column to specific dates in a column definition .
Justification
Justifies the description text that is specified in the row definition. For more information, see Apply column justification in a column definition .