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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports 2008 Oracle 11g Retrieve Person if most recent date

Status
Not open for further replies.

hmax

Programmer
Jan 22, 2012
60
US
Crystal Reports 2008
Oracle 11g

If most recent Table.CreationDateField, then show Table.PersonField.

Thanks!

hmax
 
If I understand you correctly, you only want to see one name, the one with the most recent creation date.

Sort by creation date.
Suppress Detail
Put the Name in Report Footer.
 
Hi, Charliy. I realize I should have provided more detail.

There are multiple groups in the report already. I was hoping to find a formula. Fortunately, I can place the result below all the other detail (I suppose a subreport would have worked, too). So, I created a new group based on the date, then in the suppress field, if not max then show the result for the person.

It seems to be working out.

Thanks for your help - much appreciated.

hmax
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top