Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: carry forwarded calls Post Reply Post New Topic
Author Message
sanyada
Newbie
Newbie


Joined: 28 Jan 2008
Location: India
Online Status: Offline
Posts: 3
Quote sanyada Replybullet Topic: carry forwarded calls
     Posted: 29 Jan 2008 at 3:09am
Hi
I am using call open date as one of the parameter, nowe i want to calculate number of carry forwarded calls, which are opend before todays date and are not closed on the same day but are still in open state or closed state.
So when i am using open date as parameter, i am having a problem that i am not able to retriew the carry forwarded calls, so i had tried grouping by parameter, buty unable to find the same.
i am using this to calculate carry forwarded calls.
if({incidentsm1.open_time} < {?From Date})  and  ({incidentsm1.close_time}  >=  {?From Date}) Then
Count ({incidentsm1.open_time})
else 0
 
but it is not working fine, can u suggest me some other way
 
Thanks & Regards
Sanjay Yadav
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 29 Jan 2008 at 3:19am
Hi
 
What is the value in your field {incidentsm1.open_time} is it date or datetime ?
 
can you post some sample data as what is going wrong...
 
cheers
rahul
IP IP Logged
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