subreport

rbuser

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.

nicocizik

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