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

Note 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/Unitscolumn. For more information, see Relate a format row to an amount row .

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

  3. Select a format code from the list. For a list of format codes and their actions, see the following table:

Format Code

Interpretation of Format Code

Action

(none)

Clears the Format Codecell.

TOT

Total

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

For more information, see Use a row total in a row definition .

CAL

Calculation

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

For more information, see Use a calculation formula in row definition .

DES

Description

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

LFT

RGT

CEN

Left

Right

Centre

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 Select the base row for a column calculation .

PAGE

Page

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

Draw a box around the report rows that begin with the BXBrow and end with the BXCrow.

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 Select a sorting code for a row definition .

See Also