Grouping and subgrouping?

Hi,

how to show something like this in crystal report(I'm working on .net version)

Code:

---

    state UK  - (group heder, grouping is by state field)
          columns ID | Type | Active|
          1 row    1 | Type1 | yes|
          2 row    5 | Type2 | no|
          3 row    6 | Type1 | no|
          4 row    9 | Type1 | yes|
          ...
    summary - (group footer)
          Type1: count Active=2, count Inactive=1
          Type2: count Active=0, count Inactive=1

    ... next groups

---

Problem is how to get data for group footer, I need for every Type in group count of active and inactive.
Any ideas?

regard j

Insert a non-ondemand sub report. works a treat.

Yea men, you are 100% right.

regard j