Crystal Report Sorting Problem

Hi,

I have set a formula field '@.sorting' , where {?yy} is a parameter.

Following is the formula:-

if {?yy}="1" then
{Table1.RSRCE_NME}
else if {?yy}="2" then
{Table2.PROJ_NME}

Now i have set this formula field '@.sorting' as a SortField. I am able to dynamically change the sort parameter. But i am unable to set the Order [Asc/Desc] of the sort field.

What should be done?. Please help. :)

Thanx in advance
Rajesh RajendranHi,
Goto Report > Record Sort. In the menu you can see the Formula field and table fields. Select @.sorting. Now the report will be sorted by @.sorting.

Madhivanan