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
-
On the navigation bar, click Reports.
-
In the tree view, click Custom Reports.
-
In the reports list, click the report that you want to filter.
-
On the task pane, click Edit.
-
On the properties pane, under Report Definition, click Filters.
-
Create a filter by defining one or more filter expressions.
See Filter expressions for defining custom reports.
-
Click Add.
-
Repeat step 6 and step 7 to add more filters.
-
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:
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:
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:
After you separate the expressions, they are displayed without the parentheses.
|
-
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.
-
To remove an expression, select the expression, and then click Remove.
-
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