[RESOLVED] Group by times in a hour span in Crystal Reports

[FastEddie]

I would like to group data like the data posted below by the hour. Basicaly what I want to end up with is between 8:00 and 9:00 there were 3 records. I can count the records easily enough but I don't know how to group by each hour. Anybody have an idea for me to get started with.

Store # 1101

11/01/2005 08:09:2
11/01/2005 08:28:5
11/01/2005 08:39:2
11/01/2005 09:18:3
11/01/2005 09:36:1
11/01/2005 10:13:1
11/01/2005 10:22:4
11/01/2005 10:39:5
11/01/2005 10:41:3
11/01/2005 11:01:4
11/01/2005 11:02:5
11/01/2005 11:26:5
11/01/2005 11:27:0
11/01/2005 11:59:4
11/01/2005 12:11:2
11/01/2005 12:33:4





Added [RESOLVED] to thread title and green "resolved" checkmark - Hack

[FastEddie]

Never mind I figured it out.

[Hack]

Welcome to the forums.

Post what you did to come up with your solution. It may help someone else with the same or similiar problem that, when doing search on this issue, finds this thread.

Thanks.