Showing a range of time within a date range

[zrefugee]

I need to create a report that allows a user to pick a date range but only summarizes a range of time during the days picked such as 7:00am to 3:00pm. I am using Cystal Reports 9. Any help would be greatly apprecaited.

 

[MisterMo]

You can use Running total to summarise your value

and on the evaluate section choose formula button (x-2) and enter the following

Time({Table.DateTime})>= Time("7:00am")

and Time({TAble.DateTime})<= Time("03:00pm")

if you are using groups you can reset the summary on change of group.

Mo

 

[lbass]

I think you could use a parameter for the date range and then use a record selection formula like:

{table.datetime} = {?daterange} and
time({table.datetime}) >= time(7,0,0) and
time({table.datetime}) < time(15,0,0)

-LB

 

[zrefugee]

Thanks a lot. Using the "Time" function worked great.