Compartilhar via


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

  1. In Report Designer, click Column Definitions.

  2. On the File menu, click New, and then select Column Definition.

  3. Add the information that is defined in Contents of a column definition.

Open a column definition

  1. Open Report Designer. In the navigation pane, click Column Definitions.

  2. Double-click a column definition to open it.

Add a column to a column definition

  1. In Report Designer, click Column Definitions, and then open the column definition to modify.

  2. Select a column where a new column should be inserted.

  3. 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

  1. In Report Designer, click Column Definitions, and then open the column definition to modify.

  2. Select the column to delete.

  3. 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.

    Restrict column to reporting unit in column definition

    Currency Display

    Currency Filter

    Format currency.

    Translate report 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.

    (DEU) Management Reporter and XBRL

    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.

    Column restrictions in a column definition

    Justification

    Left, center, or right justifies the description text that is specified in the row definition.

    Apply column justification in a column definition

See Also

Format columns

(DEU) Management Reporter and XBRL