CR 8.5 Change sort order

[spiced]

I have a subreport that is used to list the six required reviewers (electronic signatures) that have verified the accuracy of the data in the main report, sometimes it is necessary if changes have to be made to have the reviewers reverify. This results in more than six entries.
The subreport needs to select the last six Date & Time stamped entries, the report works if Acsending order (newest to oldest from the top down) is selected but I have been requested to put them in Desending order. In Desending order (oldest to newest from the top down) and there are more that 6 entries then the newest entry will not be shown as the first entry.

 

[CR85user]

Can you give some example data & layouts as well as the version of Crystal you are using?

Thanks

'J

 

[spiced]

Hello J, I'm using Crystal Reports (CR) 8.5. The link below is a pdf file that shows the result of the subreport.

https://secure.filesanywhere.com/v.asp?v=%89ib%8DY%5Fs%A7%9D%97

 

[Madawc]

What selection are you using? Have you considered selecting more and then suppressing some?

Or grouping and using Maximum or Minimum?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10