Sorting with parameter fields of type date, number and string
Posted on 2008-09-30
hi, i have added a parameter to my report so i can choose what to sort by.
I have managed to sort it by creating a formula with a switch function to change according to the parameter the fields its supposed to sort by. the only problem is i need to sort it by different field types.
How can i do this?
i managed sorting by date and number types, i convert the date field to numbers without "/" and it sorts perfectly. however the string (table.Name) cant be converted to number. If i convert all to String type, the numbers as string will not sort properly (for ex. 100.1 will go before 15)
what can i do so i can sort with all types?