Return Only Last Record
Now I have this
Job# 1 6/6/07
6/8/07
6/10/07
I want this
Job# 1 6/10/07
Thanks in advance for any help.
Steve
[424 byte] By [SteveAtBaker] at [2007-11-20 11:27:37] 
I am VERY new to Crystal Reports. I have several job numbers that have several payroll dates in each job. I have no problem selecting the job numbers, but my problem is I am only looking for the "Last Date" in each job.
Now I have this
Job# 1 6/6/07
6/8/07
6/10/07
I want this
Job# 1 6/10/07
Thanks in advance for any help.
Steve
# 1 Re: Return Only Last Record
On the report side create a Group on Job#, Sort the records on the date and in the Group Footer section you can show the data which hopefully will be the last date.Supress the Details and Group Header section to see the last record in the Group.
jawadhashmi at 2007-11-9 14:11:50 >
# 2 Re: Return Only Last Record
It worked great! Thanks for the help.Steve
SteveAtBaker at 2007-11-9 14:12:50 >
