on 10-24-2014 6:50 PM
I have a DB field which gives below possible values in any order
Cancel
Original
Rebill
I want to always display the corresponding record in below order of this field.
How do I apply the custom record sorter?
Vishal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vishal,
Here's what you need to do:
1) Create a formula with this code:
If {Database_field} = 'Original' then 1
else If {Database_field} = 'Cancel' then 2
else 3
2) Go ahead and add this formula field to the 'Record Sort Expert'.
-Abhilash
You can't do that with a Record Sort, you will have to do it with a Group and then you can set the order.
If you don't need to see the Group Header or Footer, you can hide them.
Good luck,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.