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

subreport

edited February 2010 in Subreports
I have a requirement where I need to group by ABC and within that group I
need another group XYZ total.
I tried using a subreport with XYZ group but it is giving inaccurate
results. the subreport is showing all the counties
for the total dataset under each facility.

Here is what I am expecting.

example :

FACILITYNAME COUNT
==========================
ST. METHODIST 25

ABC COUNTY 10
WQN COUNTY 10
XYZ COUNTY 5


MEMORIAL HOSP 30

ABC COUNTY 10
WQN COUNTY 20

thanks,

Ravi.

Comments

  • edited February 2010
    Hi Ravi,

    There should be no need to use a subreport unless you are using two separate
    datasets in a master-detail relationship. If this is a single dataset,
    simply be sure you are ordering them by the first grouping field, then the
    second field and create two nested groups. The XYZ total should be in the
    XYZ group footer and likewise for the ABC total.

    --
    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.