<p>I have a report with 2 data sources (Parent & Child), which point at different physical databases. Therefore (unfortunately!) I can't achieve what I want using SQL alone.</p>
<p> </p>
<p>I have a Table which returns rows from the Parent data source, including a number of ID values which are used in sub-tables to retrieve data from the Child Data Source. For each Id value retrieved in the (outer) parent row, there will either be zero or 1 rows returned from the (inner) Child data source. This works fine, and I am able to see all of the required information in the report from both the Parent and Child data sources.</p>
<p> </p>
<p>What I now need to be able to do is to filter the table based upon the contents of the data retrieved from the 'Child' Data Source. (i.e. Where <child_column> like '%Joe%') However, when I try filtering on the Parent table, then the 'child' columns aren't available. If I filter on the 'Child' tables only, then only the child data is filtered, not the related Parent row.</p>
<p> </p>
<p>I have 'Googled' extensively, but the only answer I found was as follows:</p>
<p> </p>
<p><em>"You will need to use an oncreate row script on the detail row of the inner table and an onrender script of the outer table's detail row to do this"</em></p>
<p> </p>
<p>However, I don't have much experience of working with BIRT scripting, so I don't really know how to set up these scripts. Does anybody know what would need to be put into these scripts, or is there another different / better way to do this?</p>
<p> </p>
<p>Many thanks in advance for your assistance</p>
<p> </p>
<p>Ian</p>
