I'm trying to figure out how to give my clients a count of individuals from a report that shows visits. I understand the concept of:
select count(distinct id) from mycursor into array aCount,

but that only gives me the grand total. On my report I've got groups of Insurance Sponsors and then within those, groups of age ranges. I would like to give distinct counts within those groups. I'm assuming I can add variables to my report - aCount for one, but how do I refer to the group header variables? I'm thinking my subtotal counting variable would be updated at the 'on entry' part of the group header and would look something like:

select count(distinct id) from mycursor into array aCount where nprimary = nprimary.

The group header breakpoint is nprimary. I know this expression won't work because the report shouldn't know the difference between the nprimary references. Anyone have any ideas?

TIA
Diana