Hi,

I have a CRM system called Goldmine with an SQL Database and I am trying to create a report using Crystal Reports XI which will filter off and show only the most recent activity for each opportunity created.

I have created a formula which uses the nthlargest function which add a yes to the record with the most recent date.

If {Conthist.ondate} = nthlargest(1,{Conthist.ondate}) then "Yes"

This has been created as a formula field called RecentActivity.

How do I apply this to the report?