|
Filtering Report Rows |
Scroll |
You may apply row filtration to a table displayed in the window: rows will only be displayed if their column values meet the set criteria or contain a particular set of characters. Commands used to perform filtration are described below.
To filter report rows, use the Apply Filter to Report
command.
The filtering criteria are displayed in the Filtering Criteria field on the Parameter Panel. Each criterion, except the first one, consists of four parts: <Operator> <Property> <Criterion> <Value>. The first criterion does not include the <Operator> part. If the window is empty, then no criteria have been set.
To set filtering criteria, do the following.
1.Click the Add Criterion
button located to the right of the Filtering Criteria field on the Parameter Panel. The following will appear in the field after the button is pressed:
•when setting the first filtering criterion: the Designation property and the Contains criterion; the property value will not be set.
•when setting the second and subsequent filtering criteria: the OR operator and a copy of the previous criterion.
2.Set the filtering criterion in the Property list on the Parameter Panel. The names of columns of the current report style are available in this list.
3.Set the filtering parameters in the Condition and Value fields.
The criterion current view is displayed in the Filtering Criteria field. For example, the Name Contains Flange criterion means that only rows that contain the word "flange" will be included in the report.
4.Enable the Match Case option for uppercase and lowercase characters to be considered in the text entered into the Value field.
5.To set the next criterion, repeat the same actions as described above.
6.To perform filtration, press the Create Object
button.
In the graphic area, the full table will be replaced by a filtered one, and a mode icon will appear in the upper right corner.
To change, add or delete filtering criteria, run the command again.
Filters created in the report are automatically saved in this report until you finish working with it. You may view, edit or disable the saved filters of an associative report inserted into a graphic document if the report is open in the Data Processing window.
When you change the report structure (e.g. by including new properties or objects in the report), filters are not reset but applied to the new report structure.
If necessary, filtering of report rows can be cancelled.
To cancel filtering of report rows, use the Cancel Filter command
.
This command is available if the Apply Filter command has been executed.
After calling this command, all filters are deleted, returning the report on the screen to its original form.
You may also click the mode icon in the graphic area to cancel filtration.