hi all,

i have a report returning list where it is grouped by city. it contains fields:

• ID (each record has unique id),
• serial(each client will have a serial to idenfy a person)
• group1 (A<B<C<D) and group2(A<B<C<D)
• and group date

each client can have multiple entries based on how many times they have visited a centre to join group so a particular serial can appear more than once. a separate running total is used to calculate distict total of group 1 and anouther for group 2. ( this works fine if serial appears once within the running total)

i want to perform a distinct count so that serial only appears once regardles if its in group one or two but my issue is there is there any way to perform a distinct count across two running totals.

 

thanks



Software/Hardware used:
crsytal reports version 11