Home
Analytics
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>
Find more posts tagged with
Comments
wwilliams
<p>Well I beat it into submission...too weird.</p>