Nested report acting oddly or is it just me

wwilliams

<p>I have a report with a main table and child aka subreport.</p>
<p>As you can see from the log I am returning two rows  (tickets) 1073 and 1074, within the detail I have another table and sub dataset to show the related work order records. What I get is the same data for both and it makes sense since I don't see the child table doing another query, I just see another dataSetOne open call.</p>
<p> </p>
<p>I do have the main table grouped by ticketid.</p>
<p> </p>
<p> </p>
<p>Log</p>
<div> </div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSet] close called.</div>
<div>Tue Jan 20 18:56:20 EST 2015  DEBUG  >>>On Create 1073</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSetOne] open called.</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSetOne]: select relatedrecord.relatedreckey, recordkey from relatedrecord, workorder  where workorder.wonum = relatedrecord.relatedreckey  and workorder.siteid = relatedrecord.siteid   and  relatedrecord.recordkey= ?</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSetOne] Bind index [1] = 1073</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSetOne] close called.</div>
<div>Tue Jan 20 18:56:20 EST 2015  DEBUG  >>>On Create 1074</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSet [dataSetOne] open called.</div>
<div>Tue Jan 20 18:56:20 EST 2015  INFO  DataSource [maximoDataSource] connection = ConnectionID:30  - CLOSED</div>
<div> </div>

wwilliams

<p>Well I beat it into submission...too weird.</p>