does the report have groups?
That can make the request implausible.
I think you are asking for sorting on three different fields, not asc/desc/some 3rd option
If so you make a static param
call it "sort by" or whatever
enter your 3 options E.g. (first name, last name, ID number)
create a formula field as
if ?sort by = "first name" then table.firstname else
if ?sort by = "last name" then table.lastname else
if ?sort by = "ID Number" then totext(table.ID,"0000000000")
IN your sort details sort by the formula field you just created
IP Logged
