Hi. I have a report that currently groups by Client Type, then by Gender, and then by age group. So it looks like this:

Cardiac
Female
16-20 56
21-30 44
--
100
Male
16-20 44
21-30 56
--
100
etc...

I would much rather be able to display this report like this:


Cardiac
16-20 21-30
Female 56 44
Male 44 56

etc...

I can't figure out a way to do this without using a large amount of stored procedures to get the individual totals, and then a final stored procedure to return it in such a way that I just display the rows as is. Any help?