Total distinct count record Totals

[RPOC]

I am doing a distinct record count, grouped by date by on a client id. I have totaled the records in a grouping to get a value for each day. I want to then total these totals so I can get a total of all the days.
example on day 1 I had 3 unique ids (in the grouping there were 6 line items)
on day 2 I had 2 ids ( there were 14 line items).

I want to create a total that will indicated that over all those groups I had 5 ids appear, not 20.

I have tried a variety of methods but cannot seem to figure this out.
any help would be appreciated.
Thanks

 

[synapsevampire]

Perhaps if you shared how you were currently creating the distinct count it would be easier for people to enchance the report.

I'll assume that you right clicked a field and selected Insert->Summary->Distinct Count and it appeared in the Group Footer.

Try creating a formula like this:

whileprintingrecords;
numbervar TotUniq := TotUniq+<select the distinct count field from the list>

Now at report footer you might use the following to display the total:
whileprintingrecords;
numbervar TotUniq

-k

 

[RPOC]

thanks, That worked. I was missing the footer part.