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
In Report Designer, click Row Definitions, and then select a row definition to modify.
Double-click the Format Code cell.
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. .gif "Note") Note
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. |