troubleshooting Question

Selecting the Most recent last performed date for each record

Avatar of Richard McLaurine
Richard McLaurineFlag for United States of America asked on
Crystal Reports
2 Comments2 Solutions76 ViewsLast Modified:
I had this question after viewing Maximum date for Crystal Reports.

I need to be able to select only the most recent complete date for each record.  I have tried everything I can think of and have failed miserably so far.  This can't be this hard.  I have tried everything I could find on the site.  Any help would be great.

Thanks
Rich

PM_ID_NUMBER      PM_GEN_WO_NUMBER      PM_DUE_DATE      PM_COMPLETE_DATE
00006514      00224806      20161231      20151201
00006514      00209934      20161231      20141208
00006514      00195108      20161231      20131216
00006514      00181568      20161231      20130204
00006514      00177627      20161231      20121115
00006515      00223658      20161130      20151027
00006515      00188866      20170731      20130701
00006515      00190107      20170831      20130819
00006515      00183780      20170331      20130321
00006515      00185105      20170430      20130401
00006515      00186295      20170531      20130506
00006576      00231802      20160930      20160516
00006576      00228092      20160930      20160301
00006576      00224832      20160930      20160104
00006576      00221174      20160930      20150910
00006576      00217433      20160930      20150608
00006576      00213522      20160930      20150311
00006576      00210092      20160930      20141215
00006577      00223670      20161130      20151102
00006577      00223671      20161130      20151102
00006577      00216222      20161130      20150604
00006577      00216223      20161130      20150506
00006577      00208837      20161130      20141110
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros