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