Format code in Management Reporter

Format codes control the content of a row. Each row is interpreted as a financial data detail row unless a code is present in the Format Code cell. The following table describes the available format codes.

Format Code

Description

Blank

Clears the Format Code cell.

TOT

CAL

Identify a row that uses mathematical operators in the Related Formulas/Rows/Units column. Totals contain simple operators (for example, + or -). Calculations contain complex operators (for example, +, -, *, /, and IF/THEN/ELSE statements).

DES

Identifies a heading line or an empty line in a report.

LFT

RGT

CEN

Align the row description text on the report page, regardless of its placement in the column definition.

CBR

Identifies a row that sets the base row for column calculations. For information, see Setting the Base Row for a Column Calculation .

PAGE

Starts a new report page.

---

Places a single line under all amount columns in the report.

===

Places a double line under all amount columns in the report.

LINE1

Draws a single thin line across the entire page.

LINE2

Draws a single thick line across the entire page.

LINE3

Draws a single dotted line across the entire page.

LINE4

Draws two lines across the entire page-a thick line followed by a thin line.

LINE5

Draws two lines across the entire page-a thin line followed by a thick line.

BXB

BXC

Draw a box around the report rows that begin with the BXB row and end with the BXC row.

REM

Identifies a row that is a remark (comment) row and should not be printed on the report. For example, a remark row might explain your formatting techniques.

SORT

ASORT

SORTDESC

ASORTDESC

Sort expenses or revenues, sequence an actual or budget variance report by the largest variance, or sort the row descriptions alphabetically. For information about the sorting format codes, see Sorting Amount Rows.

Note:  If a report contains non-amount formatting rows that relate to amount rows that have been suppressed (for example, because of zero balances), Microsoft Office PerformancePoint 2007 Management Reporter can suppress the printing of title and format rows by using the Related Formulas/Rows/Units column. For more information, see Relating a Format Row to an Amount Row.

To add a format code to a report row, do the following:

  • Double-click the Format Code cell in the row definition, and then select a code from the list.

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!

×