<p>I need to create a BIRT report with just one parameter. for example..</p>
<p> </p>
<p>111 HEB PRODUCE</p>
<p>112 HEB FROZEN</p>
<p>113 HEB SEASONAL</p>
<p> </p>
<p>This will be a list box I will create in the Report Parameters.</p>
<p> </p>
<p>the values will be the numbers</p>
<p> </p>
<p>so the parameter entered by the user will be 111, or, 112, or 113</p>
<p> </p>
<p>Then I want to break the parameter entered by the user in 3 piece, like 1, 1, 3</p>
<p> </p>
<p>and then use these three pieces in my query</p>
<p> </p>
<p>WHERE a.customerId = ? (1)</p>
<p>AND a.locationId = ? (1)</p>
<p>AND a.dockId = ? (3)</p>
<p> </p>
<p>Or any other solution to use only one parameter but check three fields in the query?</p>
<p> </p>
<p>Is this possible?</p>
<p> </p>
