Creating predefined filters

You can predefine filters in business views for end users to choose when they design or modify web reports and library components. The following example shows the basic usage.

Notes:

When the resources that are used in some predefined filters are removed from the business view, the next time when you open the Predefined Filter dialog, you will be prompted with warning messages showing the details and the filters will be removed automatically from the dialog as well.
If you want to input values manually in the filter dialogs, pay attention to the following rules:
String Value

Rules: Quote the values with single quotes.

Example1: Customers_Country='USA'.

Example2: Customers_Country in 'Australia','Germany','Mexico'

Date Value

Rules:
- Default input format supported in JReport Designer is the same as the format of the values available in the Values dialog.
- Default input format supported in JReport Studio is 'MM/dd/yyyy' for Date, 'hh:mm:ss a' for Time and 'MM/dd/yyyy hh:mm:ss a' for Timestamp.
- Both the above formats are only the input value format in the filter dialogs, and filters are done in the RDBMS side and some RDBMS have special requirements for the date format, so you need to make sure the date formats specified in the Data Format tab of the Get JDBC Connection Information dialog are supported by your database.