You can control the formatting and rounding of amounts at the report level by modifying the settings on the report definition Settingstab.

Specify other formatting options

  1. In Report Designer, open the report definition to modify. Click the Settingstab.

  2. Under Other formatting, select the formatting to use in the report. For descriptions of the options, see the formatting options later in this topic.

Other formatting options

The following table describes the available formatting options.



Use parentheses for negative numbers

Indicates negative numbers by using parentheses ( ). If you do not select this option, the report indicates negative numbers with a minus sign (-).

Display negative numbers in red

Displays negative numbers in red. If you do not select this option, the negative numbers appear in the colour that was selected for that row.

Display digit separators

Displays digit separators, for example, 120,346,000.

Display currency symbol on first row

Displays a currency symbol in all amount columns on the first row of each page. If you select this option, you do not have to enter a CSprint control in the first row of the row definition. The actual format that is used is specified in the Amount with Currency Symbolbox in the International Formatsdialogue box.

Display blanks for zero amounts

Displays spaces instead of zeros for all zero balances in the whole report.

Display rows with no amounts

Displays rows with zero balances. By default, Management Reporter for Microsoft Dynamics ERP suppresses rows with zero balances in all amount columns.

Display reports that have no active rows

Generates a report for every unit of a reporting tree, even if no amounts appear.

Empty reports might appear if title rows or other format rows are present. To prevent extraneous titles from printing on a report without amounts, relate each descriptive row to an amount row. For more information about relating rows, see Relate a format row to an amount row .

Extra lines between rows

Changes the number of lines that are printed between the report rows.

Spaces between columns

Changes the default number of spaces that are printed between the report columns.

In addition, in the Extra Spaces Before Columncell in the column definition, you can enter the number of spaces to use before a column. For more information, see Add special formatting options in a column definition.

See Also