How do I count distinct dates in a report

rbuser

Hi there,

I have a report that lists an employee and under that employee a number
of transactions that are dated. I would like to count the distinct
dates in the report. How would I accomplish this using RAP in Report
Builder?

ex.
I have the report grouped by employee then date worked. DBcalc counts
the instances of the transactions - I would like a count of 1 for each
day that has 1+ transactions, then a total for the employee.

Plesae let me know if there is someone who could help

Cheers

-Car

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Car,

There is no built-in feature to count distinct records in ReportBuilder
however this could be done fairly easily either in SQL code (with a
different dataset) or RAP code.

In RAP, you could possibly check the record value in the
DetailBand.BeforePrint event and add it to a list if it is unique. Then
after the group has finished you could check the count of the list.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com