how to sorting with parament in CR

[kspiderman]

Can somebody help me with sorting Acending and decending using parameter, column is same.
you help is most helpful

 

[vidru]

Start by creating two formulas:

//@SortAscending
if {?SortParameter} = "Ascending" then {Table.Field}

//@SortDescending
if {?SortParameter} = "Descending" then {Table.Field}

From the Record Sort Expert, add the @SortAscending formula and set the Sort Direction to 'Ascending'. Then add the @SortDescending formula, setting the sort direction to 'Descending'.

I don't know of a more elegant solution, but would love to hear of one...

-dave

 

[kspiderman]

That worked great thank you very much.