Share via


Add a format code

The Format Code cell offers a selection of preformatted choices for the content of that row. If the Format Code cell is blank, the row is interpreted as a financial data detail row.

Note

If a report contains non-amount formatting rows that relate to amount rows that have been suppressed, for example, because of zero balances, you can suppress the printing of title and format rows by using the Related Formulas/Rows/Units column. For more information, see the “Relate a format row to an amount row” section in Related formulas/rows/units.

Add a format code to a report row

  1. In Report Designer, click Row Definitions, and then select a row definition to modify.

  2. Double-click the Format Code cell.

  3. Select a format code from the list. The following table describes the format codes and their actions.

Format code

Interpretation of format code

Action

(none)

Clears the Format Code cell.

TOT

Total

Identify a row that uses mathematical operators in the Related Formulas/Rows/Units column. Totals contain simple operators, for example, + or -.

For more information, see the “Components of a row total formula” section in Related formulas/rows/units.

CAL

Calculation

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

For more information, see the “Use a calculation formula in a row definition” section in Advanced formatting options.

DES

Description

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

LFT

RGT

CEN

Left

Right

Center

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

CBR

Change Base Row

Identifies a row that sets the base row for column calculations. For more information, see the “Select the base row for a column calculation” section in Modify row definition cells.

COLUMN

Column break

Starts a new column in the report.

NoteNote
Column breaks might not display correctly when a report is exported to a XPS document.

PAGE

Page break

Starts a new report page.

---

Single underline

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

===

Double underline

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

LINE1

Thin line

Draws a single thin line across the page.

LINE2

Thick line

Draws a single thick line across the page.

LINE3

Dotted line

Draws a single dotted line across the page.

LINE4

Thick line and thin line

Draws two lines that appear as a thick line followed by a thin line across the page.

LINE5

Thin line and thick line

Draws two lines that appear as a thin line followed by a thick line across the page.

BXB

BXC

Boxed row

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

REM

Remark

Identifies a row that is a 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

Sorts expenses or revenues, sequences an actual or budget variance report by the largest variance, or sorts the row descriptions alphabetically. For more information about the sorting format codes, see the “Select a sorting code” section in Modify row definition cells.

See Also

Row definition