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

drill down sub report totals in main report

edited April 2007 in Subreports
Hi,

I'm using Report Builder 10.05 and I've been struggling for a couple of
hours to display totals of items in a drill down sub report on the main
report. I have tried using Variables and rap code to sum the totals but i
got very strange values. Has anyone been able to accomplish this?

Regards,
Jacques

Comments

  • edited April 2007
    Hi Jacques,

    When a subreport is in drilldown mode, the components contained inside the
    subreport are not automatically created until it has been drilled down.
    Since you are using ReportBuilder components to make calculations, you need
    these components to be created and calculated to obtain a correct grand
    total. You may try either making these calculations elsewhere in your
    application or perhaps calculating these sums inside another query in your
    database to remove the need for the subreport(s) to be drilled down.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.