Versago Data Views can filter data before it is displayed to the user. There are two types of filters:

• User-Applied
• User Account.

Filters associated with Crystal Reports or Stored Procedure parameters are automatically displayed in this step.

User-Applied Filters allow the user to provide input about how they want to filter the information for selection.

1. Select User-Applied Filter as the Filter Type .
2. Select the data view field to be filtered from the Field/Filter Name drop-down list.
3. Type a Display Label for the user.
4. Control Type defines the type of field used to enter the filter:
   1. Dropdown
   2. Text
   3. DatePicker
   4. Numeric
5. Required makes a filter mandatory.
6. Source is only available with the Drop-Down control type and defines how the values are generated.
   1. Dynamic creates a list of unique values from the data set.
   2. Static allows the developer to create their own list of selection values.
7. Operator sets the default filtering option.
8. Default Value sets a default filtering value. The value can be changed by the user at execution time.
9. Visible indicates if the user sees the filter. A “Default Value” must be defined if this option is used.
10. Line Break introduces a line break between filters when multiple filters are used. Otherwise, the system will auto-order the filters based on available space.

User Account filters are predefined by the Versago administrator. They are applied automatically when the data view is executed. The filtering value(s) are associated with each user. The account filters must be defined before they can be associated with a report.

1. Select User Account Filter as the Filter Type.
2. Select the Account Filter from the “Field/Filter Name” drop-down list.
3. No other information is required.

How to set up an Account Filter

1. A data view can have multiple filters.
2. User-applied filtering is applied based on the display order of the filters. This means that the first value filters the initial data set, giving a data subset. The next value then filters the first data subset, and so on.
3. User account filters are automatically applied. Filtering is done based on the data filters associated with the current user.
4. When both user-applied and user account filters are defined, the user account filter is applied first

Add/Edit Data View

Home