Home > IT Answers > Business Intelligence > how to perform a distinct count on a record over 2 sub reports
N786
5 pts.
 how to perform a distinct count on a record over 2 sub reports
Crystal Report XI, Distinct Records
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
ASKED: February 2, 2012  12:50 PM
UPDATED: February 28, 2012  2:14 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,410 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _