Sorting Records

[ode2eba]

Hello,

Firstly I'm sorry if I ask a question that may look simple to all, I'm such a newbie :)

I'd like to sort records, let's say of Top 3 Purchase Orders (by date). Using the Top N expert, my report displays it like this:

PO Number Date

1) PO A 29 Nov 2006
2) PO B 27 Nov 2006
3) PO C 20 Nov 2006

However, how do I make the report to show the oldest date of all these Top 3 records? i.e. make it to display

PO Number Date

1) PO C 20 Nov 2006
2) PO B 27 Nov 2006
3) PO A 29 Nov 2006

I've tried using the Group Sort Expert and change the records to be ascending but this didn't help.

Thanks in advance.

[TripperDay]

Use the Record Sort. It's that button with the A and Z pointing at each other. Use the PO Date field.

[jeffro308]

Hello,

Firstly I'm sorry if I ask a question that may look simple to all, I'm such a newbie :)

I'd like to sort records, let's say of Top 3 Purchase Orders (by date). Using the Top N expert, my report displays it like this:

PO Number Date

1) PO A 29 Nov 2006
2) PO B 27 Nov 2006
3) PO C 20 Nov 2006

However, how do I make the report to show the oldest date of all these Top 3 records? i.e. make it to display

PO Number Date

1) PO C 20 Nov 2006
2) PO B 27 Nov 2006
3) PO A 29 Nov 2006

I've tried using the Group Sort Expert and change the records to be ascending but this didn't help.

Thanks in advance.


insert a group for the date. sort it ascending.