Count function in Crystal
Posted on 2008-10-23
Hi. I need to do a simple record count in CR.
Fields: an integer, a datetime stamp.
I need a count by day/date/year of events each day:
5813 10/24/2008 7
5813 10/25/2008 6
SQL is a cinch:
SELECT didnumber,LEFT(CONVERT(varchar(11), starttime, 101),11) as start
WHERE (DIDNumber IN (5290, 5813))
select didnumber,start,count(*) total
group by didnumber,start
ORDER BY DIDNumber, Start
How is this done in CR Design?