Crystal Reports Sample - Summaries By Time Period
This sample crystal report shows multiple summaries by several time periods based on a user entered ending datetime. The report can be set to any datasource. Even if the datasource is missing specific dates or hours the report will still show each period.
There are instructions on the report (in Design mode > Report Header) on how you can set this report to your database.