crystal-reportscrystal-reports-2008crystal-reports-xicrystal-reports-8.5crystal-reports-server

Multiple columns in a summary field to calculate distinct count

I have in my sql return statement as

Date            Id

02/12/2012      100
02/12/2012      100
02/13/2012      101
02/13/2012      100

When i show the total visits in crystal report, i show it as

2

but actual result is

3

ie. based in date and Id.

In crystal report i have a summary field calculating the total based on

"Distinct count of date".

I want to use "Distinct count of date, Id", will that be possible in crystal reports?

so that i can get 3.

Solution

  • Create a formula that combines both data values and do a distinctCount() on that. For example, something like totext({table.date}, 'MM/dd/yyyy') + ' | ' + totext({table.ID})