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.
Software/Hardware used: crsytal reports version 11