Code for group break on date

[dunkster]

I have a User activity stats table in SQL 2000 I want to report on.
Fields are : User, Login (stored as date/time field),
KeyDepresssions.
I am printing a report with a group break on User (this bit works fine), BUT, I also want a sub group break when the date changes within the User group. What code do I need to just compare on Date only to obtain keying info on day change ???

 

[dgillz]

Write a formla like this:

Date({Login})

The group on this formula field

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

http://www.trianglepartners.com