This example shows two methods to include an ALL parameter for a data set.

Clement WongClement Wong EM mod
edited July 28, 2016 in DevShare Downloads
This is an updated version of this DevShare ( with a database as a data source.

The attached design has two examples that illustrates changing the SQL statement in the beforeOpen of the Data Set, and includes another that uses a Filter of the Data Set.

The advantage of using the first method is that the result set returned from the database will be trimmed down.

Using the second method of the Filter will return all results to BIRT, and then BIRT will perform the filtering, which, typically, will be less efficient than the first method.

Please also review this blog (http://birtworld.blo...statements.html) about the possibility of SQL injection.

Clement Wong
Principal Analytics Architect

OpenText Corporation |

Sign In or Register to comment.