Report based on Time

building reports crystal reports
1

I have a report that they want to show the following. I’m not sure who to go about this.

Parameter - single date/time value. Returns all ticket activity 3 hrs prior and 3 hrs past parameter time.

How can I get crystal to retune information that happened 3 hrs prior and 3 hrs after the date/time that is entered?

bricast (BOB member since 2009-01-29)

2

In your record selection criteria have code similar to this:

{database.ticketactivity.datetime} in
dateadd('h',-3,{?parameter}) to dateadd('h',+3,{?parameter})

Sanjay Kodidine :us: (BOB member since 2008-03-19)