Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report sorting Post Reply Post New Topic
Author Message
Suman
Newbie
Newbie


Joined: 09 Jul 2007
Location: New Zealand
Online Status: Offline
Posts: 3
Quote Suman Replybullet Topic: Report sorting
    Posted: 09 Jul 2007 at 9:27pm
Hi all,
Hope someone can help on this.  I have a field in my report that is "call number" and this is repeated several times in the report based on the different status of the call.  I have used "distinct count" to use the actual number of calls.
 
 Is it possible to have this number appear only once based on the final status of the call as the report seeker is only interested in the final status?  "status" field is in text format and varies, a final status of a call could be forwarded, pending, closed  etc.
 
Thanks
 
Suman
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 11 Jul 2007 at 12:25pm

Is there a date/time for each status?  If so, this is fairly easy.

Create a group on the Call Number field.  Add a descending sort on the date/time field.  Put the call number and status in the Call Number group header.  This way you should be able to display just the final status for the call.
 
-Dell
IP IP Logged
Suman
Newbie
Newbie


Joined: 09 Jul 2007
Location: New Zealand
Online Status: Offline
Posts: 3
Quote Suman Replybullet Posted: 18 Jul 2007 at 8:07pm
It worked
Thanks a lot!
Suman
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.016 seconds.