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.
