Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only need last date

Status
Not open for further replies.

lcp117

MIS
Oct 2, 2001
5
US
Hello. I'm working with a report that has various dates associated with one ID number. I'm using Crystal Reports 8.5, and I am rather new to the program. I need to just view the last date which is the farthest into the future with all the data accociated with it. I was able to do this by grouping by the ID first, then using a max command. But the report has to be sorted by the date field. Any suggestions? Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top