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

crystal report -sorting issue

I am new to crystal reporting
Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer.
But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.
Any suggestions on what must have gone wrong.
Thanks in advance

SandyTry checking in the
Menu File / Options / Database tab / Perrform Grouping On Server|||Hi Sandy, saw a very similar post somewhere else, this sounds odd, if it sorts correctly in CR, it should sort in ASP the same, you may want to have a web person check to make sure something is not sorting your report once it gets to the page. Sorry I am not much help...|||Try checking in the
Menu File / Options / Database tab / Perrform Grouping On Server

hi

done the changes-- but how would it reflect in my asp page

thanks

sandy|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?

NO there is no subreports in my report - its a simple report - with fields like job, description and amount. - with a total and a grand total in the end. the report is coming to from the viewer though an asp page. Its sorted in the
report but when it has sort in the asp page ... it refuses to do the same. but when i click on the job field it sorts by descending and with one more click to goes to ascending. Now i want a default ascending as in the report.
I am a newbie in asp..
If you can please help

sandy