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

See Also

Row definition