Setting filters for custom reports

Use the following steps to set filters for custom reports that you want to create.

To set filters for 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 you want to filter.

  4. On the task pane, click Edit.

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

  6. Create a filter by defining one or more filter expressions.

    See Filter expressions for defining custom reports.

  7. Click Add.

  8. Repeat step 6 and step 7 to add more filters.

  9. To combine sets of filter expressions, do any of the following:


    To combine two filter expressions so that both expressions must be true for the result to be true

    Click AND.

    For example, to find all backup jobs that failed, add the following expressions:

    • Status = Failed

    • Type = Backup

    After you set up the expressions, do the following:

    • Click AND to combine the two expressions.

    The combined expression is:

    Status = Failed AND Type = Backup

    To combine two filter expressions so that one of the expressions must be true for the result to be true

    Click OR.

    For example, to find jobs that either failed or were canceled, add the following expressions:

    • Status = Failed

    • Status = Canceled

    After you set up the expressions, do the following:

    • Click OR to combine Status = Failed with Status = Canceled.

    The combined expression is:

    Status = Failed OR Status = Canceled

    To combine two filter expressions into a single expression

    Click ( ) +

    For example, to find backup jobs and restore jobs that failed, add the following expressions:

    • Status = Failed

    • Type = Backup

    • Type = Restore

    After you set up the expressions, do the following:

    • Use OR to combine Type = Backup with Type = Restore.

    • Press and hold Ctrl while you click Type = Backup and Type = Restore.

    • Click ( ) + to combine Type = Backup with Type = Restore.

    • Use AND to combine Status = Failed with (Type = Backup OR Type = Restore).

    The combined expression is:

    Status = Failed AND (Type = Backup OR Type = Restore)

    To separate two filter expressions that were combined into a single expression

    Click ( ) -

    For example, if you used ( ) + to combine Type = Backup with Type = Restore, it is displayed on the Filters dialog box like this:

    (Type = Backup OR Type = Restore)

    To make the combined expression into two individual expressions, do the following:

    • Press and hold Ctrl while you click both Type = Backup and Type = Restore.

    • Click ( ) -

    After you separate the expressions, they are displayed without the parentheses.

  10. To change any of the expressions, do the following in the order listed:

    • In the Filter criteria box, select the expression that you want to change.

    • Click Edit.

    • In the Filter expression area, edit the expression’s values.

    • Click Update.

  11. To remove an expression, select the expression, and then click Remove.

  12. Do any of the following:


    To group fields for the report

    Do the following in the order listed:

    To sort fields for the report

    Do the following in the order listed:

    To set graph opt
    ions 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.

Setting filters for custom reports