Sorting fields in custom reports

You can sort a custom report by up to three of the fields that you have chosen for the report. When you sort on fields, Backup Exec arranges all of the data that matches the sort criteria together in the report. For example, if you sort on the Media Server field in ascending order, all data for Media Server A displays first, followed by all data for Media Server B, and so on. 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.

To sort 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 sort.

  4. In the task pane, click Edit.

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

  6. In the Sort on list, select the name of the field on which you want to sort information.

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

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

  9. Do any of the following:

    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.