Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to pull 1st history only Post Reply Post New Topic
Author Message
jhayr101681
Newbie
Newbie
Avatar

Joined: 19 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 6
Quote jhayr101681 Replybullet Topic: how to pull 1st history only
     Posted: 19 Sep 2011 at 6:16am
hi,

im very new in crystal report. i would like to ask your help about my problem in report.

i have 1table and 3 id field

i would like to pull only 1st modification of the data.

ID no    Name     Update date
1        eric     12 aug 2000
1        eric     13 aug 2001
1        eric     14 aug 2012

On this case i would like to show only the old update / 1st update and hide the rest.

everytime i pule ID no it shows all the update date.. How can i pull the 1st modification.?

Thank you guys.. Please help me.. My boss killing me.

JR
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 20 Sep 2011 at 3:23am
if the data is sorted by date, you could put the information in the group header, it would be displaying the first record of the group which happens to be the one that you want. 
 
You would need to suppress the detail sectio of the report as it would still display all the records for that id.
 
HTH
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