BIRT Exchange Forum: BIRT Exchange Forum -> BIRT Rocks!

Ever wished for a BIRT input parameter with flexibility to define a conditional clause? Actuate 11 BIRT now supports dynamic parameters that allows you to define condition clause along with parameter values.

This enables you to analyze the same BIRT report without modifying the design. For example, consider a simple customer listing table that shows customer information such as "Name", "Address", "Industry", "Country", "City", "Revenue" etc. Creating a dynamic filter on “Country” field will prompt you to enter the “Country” value along with the condition that you would like to associate with the values you choose. Change the condition to "Not in" to see data where countries are not UK or Sweden. See Video

The condition clause can be applied to data sets or report items e.g. tables, charts. The BIRT engine automatically updates the query for performance by pushing the conditions down to the database. Actuate BIRT Designer allows you to even see query execution profile for each report item that uses dynamic filter.

To create a dynamic parameters as a filter to a report item or the dataset, select the control and go to the filter tab:

You can also create a generic dynamic filter parameters in the data explorer view and apply them to report items:

Discover this new feature in the latest release of BIRT in Actuate 11, you can download an evaluation copy of BIRT designer professional from here.

Ashwini Verma