Example using Zero Suppress in the Breakout function

This example describes creating a summary report to extract the Transaction Amount for the Accounts in the range of 13000-15000 for all currency codes. The Suppress Zero in the Breakout function is used:

  1. Create a Summary Report and generate the report in Excel.
  2. Click Breakout.
  3. Add a field to the definition, for example, Currency Code.
  4. Click the Report Style tab.
  5. Select Suppress Zero and click OK.
    The report is generated with the zero value rows hidden.
  6. Copy and use the same query definition elsewhere in the report.
    1. Right-click an Excel cell and select Breakout and Currency Code.
    2. The report is generated with the zero value rows hidden.
  7. Click Summary Report and change the query definition. For example, add a new input.
  8. Click Breakout and select Currency Code.
  9. Click OK.
    The report is generated with zero value rows displayed.