Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Records with last date for specific action Post Reply Post New Topic
Author Message
tech7
Newbie
Newbie


Joined: 02 Sep 2011
Location: United States
Online Status: Offline
Posts: 5
Quote tech7 Replybullet Topic: Records with last date for specific action
    Posted: 02 Sep 2011 at 9:40am
I need to show on a report all client records with the most current date for a specific field.   For example: I want to display all the client records who contain a "P1" value in a specific field.  However, I don't want all "P1" values to display on the report for a client.  I just want the "P1" value with the most current date.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 06 Sep 2011 at 11:26am
If you don't have to do any summary calculations, this is actually fairly easy.
 
1.  If you haven't already, group by client.
2.  Sort descending on the field that contains the date for "P1".
3.  Put the data in the client group header and suppress the details section.
 
This will show the most current "P1" record for each client.
 
-Dell
IP IP Logged
tech7
Newbie
Newbie


Joined: 02 Sep 2011
Location: United States
Online Status: Offline
Posts: 5
Quote tech7 Replybullet Posted: 06 Sep 2011 at 4:35pm
Thanks.  I figured that part out.    I found out I had more which I posted in another post.   I appreciate the help though!
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.