Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Using sub report (drill down) values in the corresponding details band of main report

edited November 2010 in Subreports
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

Comments

  • edited November 2010

    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
This discussion has been closed.