multiple nested child groups in parent group question...

rbuser

I wanted to know if anyone could suggest ways that would enable us to create
a report that has multiple grouped "detail" sections inside an outer grouped
area. In other words, to have a parent group with five detail groups inside
it, where each "child" group can have any number of detail rows.

We've tried working with subreports for these, but for some reason, the data
shown in them won't follow with the outer "parent" grouped field option. It
seems to dump all the detail records per parent record instead of restricted
by the parent record's group field.

Another thing to note is that we have written our own custom SQL code which
I've tested has returned the correct "grouped" records in our database tool.
Unfortunately the SQL is more complex than what we can use with creating the
simple table data views (i.e. left outer joins, memory tables, etc...).

We are currently using Delphi 5, RB 7.04, and DBISAM 4.20 C/S

Thanks for any ideas you may have...
-Rick

nicocizik

Hi Rick,

Unfortunately, if you would like to traverse and display separate sections
of the same dataset, you will need to split that dataset up and use
subreports. My suggestion would be to have 6 separate datasets, 1 master
and 5 details. Eact detail dataset is connected to a separate child
subreport in your detail band. I created a small example that should help
you with this...

http://www.digital-metaphors.com/tips/MasterThreeDetails.zip

--
Regards,

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