I am trying to group by hourly inte

[drgonzo1972]

I am trying to group by hourly intervals from a database which measures information in 15 minute intervals: where 8.00 contains info gathered between 7:45 and 8:00, 8.15 contains data gathered between 8:00 and 8.15. When I group by hours I get data for 8.00, 8.15, 8.30, 8.45 which means my hourly intervals are for between 7.45 and 8.45....which is unacceptable. Given the way the database collates data how can I get hourly intervals which represent data for between (8.00 and 9.00 as an example) eg.when i group by hours, 9.00 would contain the data from 9.15, 9.30, 9.45 and 10.00 (which is 9-10)instead of what I have now where CR6 goes by the first digit which is 9.00, 9.15, 9.30, 9.45.

I would be much indebted to the person who can show me how to achieve this result

 

[kenhamady]

How about creating a formula that says something like:

{table.Timefield} - 60

This gives you times on the 14, 29, 44 and 59. Group on this by hour and you should get what you want.
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)