<p>Hello guys,</p>
<p> </p>
<p>I'm new to BIRT reporting and I'm having some problems, maybe you can help me out.</p>
<p> </p>
<p>I have two cascading parameters, each one being a list box.</p>
<p>The first one is an ID I am selecting and the the second one can be a list of values (an array) that are linked to the first ID.</p>
<p> </p>
<p>I have managed the array with this line on the <em>beforeOpen</em> script</p>
<pre class="_prettyXprint">
this.queryText=this.queryText.replace("999",params["ID_BOBJECT"].value.join(","));</pre>
<p>and my query looks like this:</p>
<pre class="_prettyXprint">
SELECT V_MOUVEMENT_1.*
FROM V_MOUVEMENT_1
WHERE V_MOUVEMENT_1.ID_BOBJECT IN (999)</pre>
<p>My problem is that in the end, the list of my second parameter has a blank value first and when I am creating the list selecting all the values (including the empty one) I get an error that the value is not specified.</p>
<p> </p>
<p><img src="
https://i.stack.imgur.com/GMDLL.png" alt="GMDLL.png"></p>
<p> </p>
<p>Thank you in advance for your help!</p>
<p> </p>