Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Report data by time range Post Reply Post New Topic
Author Message
63Buglover
Newbie
Newbie
Avatar

Joined: 27 Jun 2012
Location: United States
Online Status: Offline
Posts: 2
Quote 63Buglover Replybullet Topic: Report data by time range
    Posted: 27 Jun 2012 at 6:16am
I am attempting to alter an existing report to include ONLY law enforcement calls within a time range (midnight to 7am) for calls in a date period; i.e., 2010, 2011, etc.
Unfortunately, as far as I can find, all the database fields relating to time are date AND time, none with time only. How can I include only these time periods, but still have the report show for multiple dates?
Below is my current formula:

{CallUnits.CallUnitNumber} in ["D6", "D1", "D2", "D3", "D4", "D5", "DCSO"] and
{Call.ReceivedTime}= datetime({?Begin Date}) to datetime({?End Date},time(23,59,59)) and
{CallUnits.CallUnitDispatchedFrom} in ["1DCSO", "2 DCSO", "4DCSO"]


Thank you in advance for taking time to help..... John
I reject your reality and insert my own!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Jun 2012 at 6:37am
{Call.ReceivedTime} in {?Begin Date} to {?End Date} and
time({Call.ReceivedTime}) in time(0,0,0) to time(7,0,0)
IP IP Logged
63Buglover
Newbie
Newbie
Avatar

Joined: 27 Jun 2012
Location: United States
Online Status: Offline
Posts: 2
Quote 63Buglover Replybullet Posted: 27 Jun 2012 at 8:42am
Thank you! I has tried that, but it kept reverting back to the original after I exited the "Select Expert". But now I know what was happening.... I was just exiting out of the window with the "X"... I needed to "Hide Formula", then click "OK" to exit.
Thank you for your help!
I reject your reality and insert my own!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.