<p>Hi,</p>
<p> </p>
<p>I am using BIRT 3.0.</p>
<p> </p>
<p>My data looks like:</p>
<p> </p>
<p>Location Key Value</p>
<p>
</p>
<p> </p>
<p>X Code 1234</p>
<p>X Code 1235</p>
<p>X Name John</p>
<p>X Name Bose</p>
<p>Y Code 1234</p>
<p>Y Code 1237</p>
<p>Y Name Dell</p>
<p>Y Name John</p>
<p> </p>
<p> </p>
<p>Data is render in a table with aggregations and concatenation:</p>
<p> </p>
<p>Location Code Name</p>
<p> </p>
<p>X 1234, 1235 John, Bose</p>
<p> </p>
<p>Y 1234, 1237 Dell, John</p>
<p> </p>
<p> </p>
<p> </p>
<p>Parameter is Cascading Parameter</p>
<p> </p>
<p>1 - Select from Available Keys </p>
<p>2 - Populates list of available values. </p>
<p> </p>
<p>Example if they select Code</p>
<p>second parameter will show available codes 1234, 1235, 1237</p>
<p> </p>
<p> </p>
<p>If the user selects 1234 I want the table to show all locations where 1234 is shown.</p>
<p>Since Code and Name are aggregations I need to filter them individually using the parameters. Since codes are concatenated it will not recognize the selection.</p>
<p> </p>
<p>Any thoughts on how to filter the table to only show the lines that have the parameter value within the concatenated values?</p>
<p> </p>
<p>Thank you in advance!</p>
<p> </p>
<p> </p>
