Add special formatting options

Article
10/01/2014

In the column definition, the formatting column detail rows apply special formatting to selected columns. Although some of the Print Control options and Column Restrictions options are specific to FD columns, 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
Extra Spaces Before Column
Format/Currency Override
Print Control

This topic contains the following sections:

Changing column width
Add spaces between columns
Specify currency
Add a print control code
Regular Print Control codes
Conditional Print Control codes

Changing column width

The Column Width cell specifies the number of characters to use for the width of this column on the printed report. Column width is important for columns that contain amounts (column type CALC, WKS, or FD), descriptions (column type DESC), or fill (column type FILL).

By default, the AutoFit option is selected to automatically adjust the width of each column to fit the contents.

Specify the width of a column in a report

In Report Designer, open the column definition to modify.
In the Column Width cell, type the number of spaces for the width of the column. Maximum width for any column is 255 characters (including cents, commas, and parentheses).

To allow Management Reporter to select the appropriate width for the cell content, double-click the Column Width cell, and then click AutoFit

Add spaces between columns

The Extra Spaces Before Column cell specifies the width of a separator between the adjacent columns in the column definition. The Extra Spaces Before Column setting 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 Settings tab in the report definition.

Specify the space between columns

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

Specify currency

The Format/Currency Override cell 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 Override cell in an amount column.
In the Format Override dialog box, select formatting options. For more information about the dialog box options, see Select Format Override cell.

Add a print control code

The Print Control cell 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
NP	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 typical balance of row is credit	Creates a budget, or a comparative report, in which an unfavorable variance (such as a revenue shortfall or an expense overrun) is always negative. Apply this code to a CALC column. Select this code to reverse the sign of a CALC column amount if the typical balance of a given row is a credit (identified by a C in the Normal Balance column of the row definition). Note Code the appropriate rows with a C in the Normal Balance column (in the row definition) for the TOT rows and the CAL rows that typically carry a credit balance.
X0	Suppress column if all zeros or blanks	Excludes an FD column from the report if all cells in that column are either empty or contain zeros.
SR	Suppress rounding	Prevents the amounts in this column from being rounded.
XR	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.
RP	Repeat column on each page	Repeats a specified column on each page of a report. For example, to include a ROW column type that pulls in row codes on every page, use RP.
WT	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 Control cell.
In the Print Control dialog box, select a code in the Select print control options list. To select more than one code, hold down the Ctrl key while you select the codes.
Select an option in the Conditional print options field. 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 Control cell. Separate multiple print control codes with a comma.

Share via