Column definitions in financial reports-Visualpath

1. Column definitions in financial reports-Visualpath This article provides information about column definitions. A column definition is a report component, or building block, that defines the contents of columns on a report. Like row definitions, basic column definitions can be used on multiple reports. Create and modify a column definition A column definition can contain two to 255 columns. Create a column definition 1.In Report Designer, in the navigation pane, click Column Definitions. 2.On the File menu, click New, and then click Column Definition. 3.Add the contents of the column definition. Open a column definition 1.In 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 the 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: A column of the descriptions for the row definition Amount columns that show data from the financial data or calculations that are based 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, can span multiple columns, or can apply to columns on a conditional basis. The column definition can include as many column header rows as you require. 

2. Column detail rows are the rows under the header rows in the column definition. Column detail rows define the information that is included on the report. Restrict a column to a reporting unit 1.In Report Designer, open the column definition to modify. 2.Double-click the Reporting Unit cell for the column to restrict. 3.In the Reporting Unit Selection dialog box, in the Reporting tree list, select a tree. 4.Expand or collapse the list of units, select a reporting unit, and then click OK. Format column headers You can add, modify, and delete the headers that appear at the top of the columns on a report. You can also configure conditional spanning column headers, based on the Period field from column definitions and the Base Period field from report definitions. The base period feature helps save you time when you create rolling forecast reports. For more information Click Here Contact us: 9989971070