nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report Parameters

jlindsey

I am new to Birt and am trying to set up my report parameters so that the user can choose either ALL or a specific Staff Member...I don't know how to get it to recognize the "ALL". Any help would be greatly appreciated.
 
Joy

Find more posts tagged with

Comments

micajblock

Maybe this will give you an idea - <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/'>http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/</a>

chetan_1981

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="144733" data-time="1469478886">
<div>
Maybe this will give you an idea - <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/'>http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/</a>
</div>
</blockquote>
Hi,
 
Please advice or provide link of how to to do the same parameters (Filter Selection : All OR Specific Value) using database.

Clement Wong

The attached 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 (<a data-ipb='nomediaparse' href='http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html'>http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html</a>) about the possibility of SQL injection.