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

Clement Wong
Clement Wong E mod
edited February 11, 2022 in Analytics #1
This is an updated version of this DevShare (http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/) with a database as a data source.<br />
<br />
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.<br />
<br />
The advantage of using the first method is that the result set returned from the database will be trimmed down.<br />
<br />
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.<br />
<br />
Please also review this blog (http://birtworld.blo...statements.html) about the possibility of SQL injection.
Warning No formatter is installed for the format ipb