I have been scouring the web for samples\solutions to my quandry.
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.
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.
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.
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.
We have some PM's that have up to 150 assets associated to them, so scroll-ability would be a factor as well.
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.
If someone please detail step by step what I need to do to get this working, I will be eternally greatful.