We need to change the sort order in which Transaction Types appear on our employee termination statements.
Currently the Transaction Types appear in no particular order.
We use SAGE Payroll that uses Report Builder ( SAGE call it Report Writer ) to access the back end database.
The attached is a sample of a termination statement we're developing that are given to employees upon their leaving.
Also attached is a view of the report's underlying design in report builder highlighting the field that need sorting.
How would we sort the Transaction Type in this order :-
( or generally how do we sort this field at all? )
Term Post 93 AL Gross
Term Post 93 LL Gross
Hours by Rate
Of course we could drop this report into Excel and do it there, but we require it done within the ReportBuilder itself.