Home
Designing Analytics Reports
Issue - child data sets
Migrateduser
<p>Version: 431</p>
<p>Type: Open Source</p>
<p> </p>
<p>I’m building a simple BIRT report and am running into an issue I was hoping you might be able to help with.</p>
<p> </p>
<p>I have a report that I'm trying to pass a parameter from the parent dataset to the child dataset. </p>
<p> </p>
<p><strong>Parent </strong>- Select wonum, description, assetnum from workorder; </p>
<p><strong>Child </strong>- Select workhist from assetworkhistory where assetnum = rows[0]["assetnum "]</p>
<p> </p>
<p>I also have my report grouping on wonum. </p>
<p> </p>
<p>My problem lies in that if I have multiple work orders (wonum) the child will only display data from the first work order. </p>
<p> </p>
<p>So if I have 12 work order numbers, each printed work order will only display the asset information for the first work order. </p>
<p> </p>
<p>I’m sure I’m missing something small and simple – any ideas?</p>
Find more posts tagged with
Comments
There are no comments yet