Grouping fields in custom reports

You can group a custom report by up to three of the fields that you have chosen for the report. Grouping fields creates sections on the report. For example, if you group by media server, Backup Exec creates a section for each media server that matches the filter criteria. Under each media server's section, the report displays the data that corresponds to the remaining fields that you selected for the report.

A report must have at least one field that is not grouped. For example, if you select three fields in the report, you can group only two of the fields. If you group all of the fields, no data appears on the report because all of the data is listed in the group section titles. In addition, you must have at least four fields on the report to use all three grouping fields.

After you select a field on which to group the report, you can group the data for that field in ascending or descending order. Ascending order lists numbers from smallest to largest and lists letters in alphabetical order. Descending order lists numbers from largest to smallest and lists letters in reverse alphabetical order. For example, if you group by a date field in ascending order, the report data is grouped by date, starting with the earliest date.

To group fields in custom reports

  1. On the navigation bar, click Reports.

  2. In the tree view, click Custom Reports.

  3. In the reports list, click the report that contains the fields you want to group.

  4. In the task pane, click Edit.

  5. On the properties pane, under Report Definition, click Grouping.

  6. In the Group by box, select the name of the field on which you want to group data.

  7. Click Ascending to group the information in ascending order or click Descending to group the information in descending order.

  8. If you want to group on additional fields, in the Then group by box, repeat step 6 and step 7.

  9. Do any of the following:

    To sort fields for the report

    Do the following in the order listed:

    To set graph options for the report

    Do the following in the order listed:

    To preview and test the report

    Do the following in the order listed:

    • On the properties pane, under Preview, click Preview.

    • To test the report, on the Preview dialog box, click Test Report.

    To finish and close the report

    Click OK.