Using sub report (drill down) values in the corresponding details band of main report
Hi,
I can understand how to get data from sub reports and put in onto the main
report, using oncalc events.
My problem is that I want to put it onto the detail band and then have the
operator drill in to see where that data comes from.
RB seems to traverse the sub report AFTER the main detail that would call
the drill down sub report has been run.
The only ways I can see to do this seem pretty inefficient.
Kind Regards
David
David Wenham davidw@mtntop.com.au Mountaintop Systems Pty Ltd 7 Devlin Pl
Menai NSW 2234 Ph : 02 9543 8337 Fax: 02 9541 1348 www.mtntop.com.au
I can understand how to get data from sub reports and put in onto the main
report, using oncalc events.
My problem is that I want to put it onto the detail band and then have the
operator drill in to see where that data comes from.
RB seems to traverse the sub report AFTER the main detail that would call
the drill down sub report has been run.
The only ways I can see to do this seem pretty inefficient.
Kind Regards
David
David Wenham davidw@mtntop.com.au Mountaintop Systems Pty Ltd 7 Devlin Pl
Menai NSW 2234 Ph : 02 9543 8337 Fax: 02 9541 1348 www.mtntop.com.au
This discussion has been closed.
Comments
For the main report, I would create a summary query that uses SQL to calc
the summary values. Then the subreport can expand and show the detail from a
separate detail query.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com