You can define one or more filters for each folder in a universe. Filters restrict the data that can be retrieved from the underlying database tables. You can create as many filters for each folder as you like. The report designer using Easy Reporter can select any number of these filters when creating a report.
You can also create a filter that is always applied to a report based on the current universe.
To create a filter:
1. Click the Filter tab to bring the tab to the foreground.
2. Select the menu option CreateÆCreate Filter, click the Create Universe Filter icon or click the New button at the bottom of the Filter tab. The New Filter window is displayed, as shown in Figure 216.
|
3. Enter a name for the filter in the Filter Name: field. The filter name is displayed in the Easy Reporter window unless the filter is mandatory.
4. Select the Force the use of this filter by all reports based on this universe checkbox if the filter is to be mandatory. The report designer using Easy Reporter cannot see the filter, however, the filter is always applied to the report.
5. Enter a description of the filter. This field is optional.
The description is displayed when the report designer uses the Easy Reporter Get Information command on the filter.
6. Build the conditions for the filter. You can write and edit the condition in this field or insert condition components using the buttons and fields below.
The condition is displayed when the report designer uses the Easy Reporter Get Information command on the filter.
7. To include a column in the condition expand the tables in the Available Folders and Items list until you find the required column. Ensure the cursor is in the correct position in the condition and double-click the column name to insert the name.
8. To enter a boolean or arithmetic operator, click the operator button.
9. To combine multiple conditions use the AND and OR operator buttons. These buttons start a new line in the condition field.
10. To include a specific value in a column use the Lookup button. The Select a Value window is displayed.
For example, Figure 217 shows the Select a Value window for the column reporter.REP_SEVERITY_TYPES.NAME.
|
Double-click a value to insert the value into the condition.
11. To add a function to the condition click the Functions button. The Select a Function window is displayed, as shown below.
|
Double-click the function to insert the function into the condition.
12. When the condition is complete click the OK button. The filter appears on the Filter tab.
The report designer using Easy Reporter cannot use a universe filter until it has been added to a universe folder.
Note:
You can add a filter to any folder in the universe. The behavior of the filter is not affected by the folder it belongs to, however, to simplify the task of creating the report, you should add the filter to the folder it limits.
To add a filter to a folder:
1. Select the filter in the Filter tab.
2. Select the target folder in the Folder and Items tab.
3. Click the <<Add button at the bottom of the Filter tab. The filter appears below the items in the selected folder, as shown below.
|
1. Select the filter below the folder in the Folders and Items tab or in the Filter tab.
2. Select the menu option PropertiesÆUniverse Object or double-click the name of the filter. The Edit Filter Properties window is displayed.
3. This window is identical to the New Filter window, as described in the previous section.
4. Edit any of the attributes of the filter.
5. Click OK to update the filter. All instances of the filter in the Folders and Items tab and the Filter tab are updated.
To remove a filter select the filter in the Filter tab and click the Remove button. All instances of the filter in the Folders and Items tab and the Filter tab are removed.