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 |
---|
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
-
In Report Designer, click Row Definitions, and then select a row definition to modify.
-
Double-click the Format Codecell.
-
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 . |