<p>Hi Everyone,</p>
<p> </p>
<p>I have been scouring the web for samples\solutions to my quandry.</p>
<p> </p>
<p>I am trying to develop a report (Eclipse 3.7.1) that drills down on a PM, so when the user clicks on the PM number the Asset infromation associated to that PM is displayed.</p>
<p> </p>
<p>I would prefer that this is all done in the same report, the big difference is the Data source we use, is configured differently to all of the examples I have looked at, which has lead to great confusion.</p>
<p> </p>
<p>Basically I have two data sets, one with the PM details, the other with the Assets that are linked to the PM, I want the users to click the PM number so that a drill down group will present the asset details to the user for that PM. <br><br>
My first dataset that has the PM information, which has 7 fields, whereas the second data set has 4 fields related to the asset, but many rows may be returned per PM.</p>
<p> </p>
<p>We have some PM's that have up to 150 assets associated to them, so scroll-ability would be a factor as well.</p>
<p> </p>
<p>Because I have had to add the SQL queries to the OPEN and FETCH scripts of the data sets, I am now confused as to how to get the drill down aspect working.</p>
<p> </p>
<p>If someone please detail step by step what I need to do to get this working, I will be eternally greatful.</p>
<p> </p>
<p> </p>
