Sort By Parameter 1

[CrystalProgDev]

User want to have a sort by paramter selction by a name aor date.

I came up with a formula
If {?@SortOrder} = 1 Then
{Report;1.Applicant} -- String
Else
CStr({@Date})

@Date is a formula.

When user select date, the data is not getting sorted by date properly. Can anyone help me.

Thank you in advance

 

[lbass]

Change it to:

If {?@SortOrder} = 1 Then
{Report;1.Applicant} -- String
Else
totext({@Date},"yyyy/MM/dd")

-LB

 

[CrystalProgDev]

ToText ---- Still the same problem. The Date formula has if then else stmt.

 

[CrystalProgDev]

Sorry, it is working....
How to have sort order - name ascending and date descending in this case?

 

[lbass]

Create two separate formulas and add them to your record sort:

//{@App} - specify ascending sort:
If {?@SortOrder} = 1 Then
{Report;1.Applicant}

//{@Date} - specify descending order
If {?@SortOrder} <> 1 Then
totext({@Date},"yyyy/MM/dd")

-LB

 

[CrystalProgDev]

Thank you for your help. I really appreciate.

Thank you again