Adding Breaks, Sorts, and Calculations

You can add breaks to a report to group related information in tables and add predefined business calculations to table columns or rows displaying measures. You can also sort values displayed in tables and charts. You select all of these options on the Properties tab.

  1. Properties tab – this is where you add breaks, sorts, and calculations to a report.

  2. Current Report – select a report here to define its data content and formatting.

  3. Result Preview pane – provides a graphical preview of the report structure. You select a specific area of a report, table, or chart here. You can then define breaks, sorts, or calculations for the object selected in the Select an Object pane.

  4. Select an Object pane – select the object on which you want to add a break, sort, or calculation.

  5. Breaks pane – add a break and define the properties for the break here.

  6. Sort pane – select a sort order here.

  7. Calculation – select one or more calculations to insert them in a table footer.

  8. Back button – returns to the Report Filters tab.

  9. Next button – advances to the Format tab.

  10. Run/Apply button – runs the query or applies modifications, and generates the report.