>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
Create a data grouping in your report. Copy one of the fields from the detail band into the group summary. Double-click on the field in the group summary band. Click the Calculations button. Check the Count box.
Mark McCasland
Midlothian, TX USA