In my application they need to output to a spreadsheet ALL ACTION records held on the system.
These ACTION record have a primary key of Cust Ref #.
And for each Cust REF # there are multiple ACTION records in the system on varying Action Dates.
So the exported file I need to be sorted by Cust Ref # BUT ALSO by Action Date order.
Maybe I am missing something but looks like we can only sort by a single criteria ???
I know it can all be manipulated post export, sorted etc but it would be nice to take the need to massage the data even further once it is exported.
Any clues ideas comment ????