Enabling user filtering after data retrieval
This option is available for all data sources, including JDBC, XML, and text file, but filtering at query run time using data set parameters is the preferred approach for JDBC for performance reasons.
Though the goal in enabling users to filter at query run time and after BIRT retrieves the data is the same, the steps are different. To enable users to filter after data retrieval, complete the following tasks in the recommended order. For detailed information about these tasks, see the corresponding topics later in this section.
Create report parameters to prompt a user to specify field values that determine what data to display.
Create one filter condition for each field for which you want the user to supply a value. Set the value of each filter condition to a report parameter to dynamically update the filter condition with the parameter value.
Determine how to present the report parameters.
Test the report parameters.