Grouping Records In Crystal Reports?Jan 4, 2012
I have a table in my oracle database, with the following schema: student(studentNumber,name, dateOfCreation).
dateOfCreation is the date in which the student record was created.
In crystal reports, I have to group the records into the following groups, using the dateOfCreation field:
Older than 4 weeks(Records whose dateOfCreation is more than 4 weeks ago). Between 2 and 4 weeks (Records whose dateOfCreation is more than 2 weeks ago, but less than 4 weeks ago). Between 1 and 2 weeks(Records whose dateOfCreation is more than 1 week ago, but less than 2 weeks ago). Less than 1 week (Records whose dateOfCreation is less than 1 week ago).
I have tried grouping in specified order using group expert