I am using a database view for designing crystal reports.
That view has data collected for every 5 mins.

In my report I want to find the sum of a particular field say "x" for every hour in the selected duration(start date till end date).

The summary function in crystal reports will provide the results for selected option say "Sum" but it will give the sum of "x" which we get every 5 mins (collection interval).

In our report we want to add the values for every hour and not 5 mins i.e. if we consider the start date as "7/14/2008 12:00:00 AM" then we want to add the value of parameter "x" at "7/14/2000 1:00:00 AM", "7/14/2000 2:00:00 AM", "7/14/2000 3:00:00 AM", and so on till the end date.

But the database has values for every 5 mins interval i.e. "7/14/2000 1:00:00 AM", "7/14/2000 1:05:00 AM", "7/14/2000 1:10:00 AM", and so on.

We want to skip the values in between and add only the hourly value.

How this can be achieved.

I am trying running total fields option

In this I have given conditions as follows:

Field to summarize: <parameter 'x' whose addition needs to be done>

Type of summary: sum

Evaluate
On change of group: <done grouping on timestamp for each hour>

Reset
On change of group: <done grouping on host for which need to add values of parameter 'x'>

I guess this should give me the expected results but somewhere it is still failing.

Need advice on this.