Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (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>