CRXI - Group by time interval

[mgason]

Hi,
I have weighments that have a time stamp in the database.
The user selects a date range from which to retrieve a list of all weighments.
How can I group those weighments by a preset time interval.

For example if they are allowed to select a single 24 hour period. How could I group weighments in 1 hour intervals and give counts of batches for each hour.

I may need to do a similar things with day and week intervals in other reports. So any tips for that too would be great.

thanks
mark

 

[lbass]

Why not just insert a group on your datetime field on change of hour?

-LB

 

[mgason]

Yes,
I figured that out. I did not know change of hour was an option once you grouped by a date time.
thanks