CR XI - Selection formula to Limit to Max Date Records 1

[pndMaster]

Hello

I have below data records and would like only to show the max date row records

ID SvcDate SvcName Provider ClientId
1 10/01/2015 TESTING ABC 123
2 11/20/2015 CBC XYS 123
3 12/1/2015 CHEM 7 ABC 245

Result should be below (only MAX SvcDate record)
ID SvcDate SvcName Provider ClientId
3 12/1/2015 CHEM 7 ABC 245

Appreciate the guidance

Regards

 

[Charliy]

suppress the detail, sort by date, put all the data in the group footer

 

[pmax9999]

Another alternative would be to use a Group Selection Formula like this:

{Data.SvcDate} = Maximum({Data.SvcDate})

Hope this helps.



Cheers
Pete

 

[pmax9999]

I see you continue to just post questions without ever providing feedback to those who take the time to assist, notwithstanding a request from SkipVought in thread767-1757630 to acknowledge the helpful responses.

Don't be surprised if the people who usually help you suddenly stop making the effort.