Count of records per date 2

[Saint1234]

Hi all,
I have a report which has a series of records taken over a date range. Each record contains an address, dateTime and status. The date range is select through a parameter that i have created. What i need to know is, is there a way that I can add the number of records per day? The dateTime field is populated from SQL server in the format
'24/06/2004 14:44:49' I need to be able to count how many records there are for the 24/06/2004, 25/06/2004 etc. Hope someone can help.

Many Thanks in Advance
G

 

[dgillz]

are you grouping by day?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[dGrouse]

Group by your datetime field, by day, and then add a summary field on an appropriate detail field to count your records by day.

Jeff Prenevost
IS Administrator
Emergency Physicians Medical Group, PC
Ann Arbor, MI

 

[lbass]

You could create a formula {@date} and group on it:

date({table.datetime})

Then right click on this formula in the detail section and insert a count.

-LB

 

[lbass]

Oops, right, you don't even need the formula.

-LB