Adding a special formatting option in Management Reporter

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.

Note:  The formatting in the row definition overrides any formatting in the column definition. The formatting used in the column definition overrides any formatting in the report definition.

The formatting rows are as follows:

Column Width

Extra Spaces Before Column

Format/Currency Override

Print Control

For more information

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

  • 10 characters for a fill column

The maximum width for any column is 255.

Specify the width of a column in a report

  • In a Column Width cell of a column definition, type a number.

    Tip: To let Microsoft Office PerformancePoint 2007 Management Reporter select the appropriate width for the cell content, double-click the Column Width cell, and click AutoFit.

Top of Page

Extra Spaces Before Column

The Extra Spaces Before Column cell specifies the width of a separator between the adjacent columns in the column definition.

Note:  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.

Include extra spaces before a report column

  • In an Extra Spaces Before Column cell of a column definition, type a number.

Top of Page

Format/Currency Override

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

  1. Double-click a Format/Currency Override cell in an amount column of a column definition.

  2. In the Format Override dialog box, select the formatting options.

Top of Page

Print Control

The Print Control cell can contain codes that adjust the display or the printing characteristics of a column.

The following table describes the regular Print Control codes for a column definition.

Print Control Code

Description

NP

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

If you want 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 i s included in the following calculation: B+C+D However, the non-printing column C is not included in the following calculation: B:D

XCR

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 normal 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 normally carry a credit balance. When exporting reports to Formatted Excel, do not select Export Formulas. If you select this option, Excel will ignore reverse credit values, and your reports may be unfavorable.

XO

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

SR

Prevents the amounts in this column from being rounded.

XR

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

RP

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

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.

The following table describes the conditional Print Control codes for a column definition.

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

  1. Double-click the Print Control cell in the column definition.

  2. In the Print Control dialog box, select one or more codes, and then click OK.

    Tip: Alternatively, you can type the print codes directly into the Print Control cell. Separate multiple print control codes with commas.

Top of Page

For more information

See the following topics for more information:

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×