Table Binding Using A Multi-Select Parameter

joeguzman1

Hello,<br />
I am attempting to query data using a multi-select report parameter<br />
<br />
Dataset <strong class='bbc'>DS_NAME</strong><br />
<br />
<em class='bbc'>SELECT NAME,ID FROM TBL_NAME WHERE ID IN <strong class='bbc'>(?)</strong></em><br />
<br />
Report Parameter <strong class='bbc'>prmName</strong> (multi-select listbox)<br />
<br />
<br />
Report contains a table referencing dataset DS_NAME<br />
<strong class='bbc'>Databind: parm_1 = params["prmName"].value</strong><br />
<br />
Preview - No data extraced!<br />
<br />
<strong class='bbc'>What am I doing wrong?</strong><br />
<br />
Thank you

johnw

Check the following two blog entries:
http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html
http://birtworld.blogspot.com/2009/04/multi-select-parameters-part-2.html