The Format Overridecell specifies the print format for the row. This numerical format overrides the formatting that is specified in the column definition and the report definition, which, by default, is currency. If the report lists the number of assets in one row, such as number of buildings, and their monetary value in another row, you can override the currency formatting and enter numeric formatting for the row that specifies the number of buildings.

Specify this information in the Format Overridedialogue box. The available options depend on the format category that you select. Example formats are displayed in the Samplearea of the dialogue box.

The available format categories are:

Override cell formatting

  1. In Report Designer, open the row definition to modify.

  2. Double-click a cell in the Format Overridecolumn.

  3. In the Format Overridedialogue box, select the formatting options to use in the report.

  4. Click OK.

Currency formatting

Currency formatting applies to a fiscal amount and includes the currency symbol. The following options are available:

  • Currency symbol– The currency symbol for the report. This value overrides the Regional Optionssetting for the company information.

  • Negative numbers– Negative numbers can be displayed with the minus sign (-) or in parentheses ( ).

  • Decimal places– The number of digits to show after the decimal point.

  • Zero value override text– The text to include in the report when the amount is zero. This text appears as the last line in the Samplearea.

Note Note

If printing is suppressed for zero values, this text is also suppressed.

Numeric formatting

Numeric formatting applies to any amount and does not include a currency symbol. The following options are available:

  • Negative numbers– Negative numbers can be displayed with the minus sign (-) or in parentheses ( ).

  • Decimal places– The number of digits to show after the decimal point.

  • Zero value override text– The text to include in the report when the amount is zero. This text appears as the last line in the Samplearea.

Note Note

If printing is suppressed for zero values, this text is also suppressed.

Percentage formatting

Percentage formatting includes the percent sign (%). The following options are available:

  • Negative numbers– Negative numbers can be displayed with the minus sign (-) or in parentheses ( ).

  • Decimal places– The number of digits to display after the decimal point.

  • Zero value override text– The text to include in the report when the amount is zero. This text appears as the last line in the Samplearea.

Note Note

If printing is suppressed for zero values, this text is also suppressed.

Custom formatting

Use the custom format category to create a custom format override. The following options are available:

  • Type– The custom format.

  • Zero value override text– The text to include in the report when the amount is zero. This text appears as the last line in the Samplearea.

The type should represent both the positive, and then the negative value. Typically, you enter a similar format differentiating between positive and negative values. For example: 0.00;(0.00)

The following table shows custom formats that can be used to control how your values should be formatted. These examples start with a value of 1234.56.

Positive

Negative

Zero

0

1235

-1235

0

0;0

1235

1235

0

0;(0);-

1235

1235

-

#,###;(#,###);“”

1,235

(1,235)

(blank)

#,##0.00;(#,##0.00);zero

1,234.56

(1,234.56)

zero

0.00%;(0.00%)

123456.00%

(123456.00%)

0.00%
Note Note

If printing is suppressed for zero values, this text is also suppressed.

See Also