I have a 'transaction summary' database which is basically a log of every transaction that occurs over our network. Each entry in the database has information such as: Time, Source IP, Destination IP, Transaction Type, and some other things.

 

I'm trying to create a report that calculates the 'busiest one hour period'. Basically, I want crystal reports to do a count of the number of transactions for each 1 hour period (e.g. 1:00-1:59, 2:00-2:59, etc.) and tell be which of these periods had the most transactions. For example, lets say I had the following databse entries:

 

 

I have a followup to that quesiton.

 

Lets say instead of just the time field, there was a DateTime field. Now, in addition to being able to display the 'busiest hour' I also want to display the 'busiest day'.

 

Keep in mind that the busiest hour is not necessarily during the busiest day. As such, I'm not sure if the grouping idea above would still work.

 

thanks in advance