Specifying Other formatting in Management Reporter

The settings in the Other formatting area control formatting and rounding of amounts at the report level.

Other 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 don't select this option, the negative numbers appear in black.

  • 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 need to enter a CS print control in the first row of your row definition. The actual format that is used is specified in the Amount with Currency Symbol box in the International Formats dialog box.

  • Display blanks for zero amounts

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

  • Display rows with no amounts

    Displays rows with zero balances. By default, Microsoft Office PerformancePoint 2007 Management Reporter suppresses rows with zero balances in all amount columns.

  • Display reports with 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 Relating a format row to an amount row.

  • Extra lines between rows

    Changes the number of lines that print between the report rows.

  • Spaces between columns

    Changes the default number of spaces that print between the report columns.

    In addition, in the Extra Spaces Before Column cell in the column definition, you can enter the number of spaces to use before a column.

Specify other formatting options

  1. In an open report definition, click the Settings tab.

  2. In the Other formatting area, select the check boxes for the formatting that you want to use in the report.

  3. In the Extra lines between rows box, type the number of extra lines to add.

  4. In the Spaces between columns box, type the number of spaces to add between columns.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!