In the column definition, the formatting column detail rows apply special formatting to selected columns. Although some of the Print Controloptions and Column Restrictionsoptions are specific to FDcolumns, most of the options apply to all column types. The formatting in the row definition overrides the formatting in the column definition. The formatting used in the column definition overrides the formatting in the report definition.

The following rows are considered formatting rows:

Column Width

The Column Widthcell specifies the number of characters to use for the width of this column on the printed report. Column width is particularly important for columns that contain amounts (column type CALC, WKS, or FD), descriptions (column type DESC), or fill (column type FILL). The default column widths are as follows:

14 characters (including cents, commas, and parentheses) for amount columns
30 characters for the description columns
2 characters for a fill column

The maximum width for any column is 255.

Specify the width of a column in a report

In Report Designer, open the column definition to modify.
In the Column Widthcell, type the number of spaces for the width of the column. To allow Management Reporter to select the appropriate width for the cell content, double-click the Column Widthcell, and then click AutoFit.

Extra Spaces Before Column

The Extra Spaces Before Columncell specifies the width of a separator between the adjacent columns in the column definition. The Extra Spaces Before Columnsetting affects all column detail rows, but not the column header rows, for this column.

Use this option to separate groups of columns or to add a few spaces before the description so that the description column is indented from the left-justified titles that are in the report.

The default number of spaces between each column is two. You can change this option on the Settingstab in the report definition.

Specify the space between columns

In Report Designer, open the column definition to modify.
In the Extra Spaces Before Columncell, type the number of spaces to insert between columns.

Format/Currency Override

The Format/Currency Overridecell specifies the formatting of the decimal, currency, and percentage amounts in this column. This formatting overrides any formatting that is specified in the report definition or system defaults.

Assign a format currency override to a report column

In Report Designer, open the column definition to modify.

Double-click a Format/Currency Overridecell in an amount column.

In the Format Overridedialogue box, select formatting options. For more information, see Select Format Override cell in row definition .

Print Control

The Print Controlcell can contain codes that adjust the display or the printing characteristics of a column. There are Regular Print Control codes and Conditional Print Control codes .

Regular Print Control codes

Print Control Code

Translation

Description

Nonprinting

Excludes the amounts in this column from printing in the report and from calculations.

To include a non-printing column in a calculation, refer to the column directly in the calculation formula. For example, the non-printing column C is included in the following calculation: B+C+D. However, the non-printing column C is not included in the following calculation: B:D.

XCR

Change sign if normal balance of row is credit

Creates a budget, or a comparative report, in which an unfavourable variance (such as a revenue shortfall or an expense overrun) is always negative.

Apply this code to a CALCcolumn.

Select this code to reverse the sign of a CALCcolumn amount if the normal balance of a given row is a credit (identified by a Cin the Normal Balancecolumn of the row definition).

Note
Code the appropriate rows with a Cin the Normal Balancecolumn (in the row definition) for the TOTrows and the CALrows that normally carry a credit balance.

Suppress column if all zeros or blanks

Excludes an FDcolumn from the report if all cells in that column are either empty or contain zeros.

Suppress rounding

Prevents the amounts in this column from being rounded.

Suppress rollup

Suppresses a rollup. If the report uses a reporting tree, the amounts in this column are not rolled up into subsequent parent nodes.

Repeat column on each page

Repeats a specified column on each page of a report. For example, to include a ROWcolumn type that pulls in row codes on every page, use RP.

Wrap text

Wraps text. If the text in a column is too long to fit the space, this option wraps the text to keep all of the text in the column.

Conditional Print Control codes

Conditional Print Control Code	Description
(none)	Clears the conditional print selection.
P<B	Displays a specified column only if the period is less than the base period.
P>B	Displays a specified column only if the period is greater than the base period.
P=B	Displays a specified column only if the period is equal to the base period.
P<=B	Displays a specified column only if the period is less than or equal to the base period.
P>=B	Displays a specified column only if the period is greater than or equal to the base period.

Add print control codes to a report column

In Report Designer, open the column definition to modify.
Double-click the Print Controlcell.
In the Print Controldialogue box, select a code in the Select print control optionslist. To select more than one code, press and hold the Ctrl key as you select the codes.
Select an option in the Conditional print optionsfield. By default, (none)is selected. You can select only one conditional print code at a time.
Click OK.

Tip
Alternatively, you can type the print codes directly into the Print Controlcell. Separate multiple print control codes with a comma.