In Crystal Reports sorting by either a date or a number column 1

[jchewsmith]

I have a report that I want to put in a paramater to sort by either the due date column of the quoted amount column.

I have tried to group by the sort option but it doesn't allow two different field types.

Is there a way to have a parameter to let the user choose which column they want to sort by when they are two different field types?

if {?Sort Option} = 'Quoted Amount' then {SSRpt_NOW.Quoted Amount}
else {SSRpt_NOW.DUE DATE} I GET AN ERROR MESSAGE EXPECTING A NUMBER AFTER THE ELSE.

 

[kray4660]

Part of the issue is that the THEN of the IF and the ELSE of the IF have to be the same data type. If you can convert the one (or both) of the fields to a common data type, it might work for you.

 

[SkipVought]

In VB you can convert a date to a LONG integer or DOUBLE precision using a function.

Do you have such a conversion function?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jchewsmith]

I tried converting the date to an integer but couldn't figure out how to do. Any ideas?

 

[Madawc]

You can use ToText to convert both to 'string'. For dates, something like

ToText({your.date}, "yyyy/MM/dd")

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[lbass]

You can use the totext function as suggested, or you could add two formulas to the sort records area:

if {?sort} = "Amount" then {table.amount}

if {?sort} = "Date" then {table.date}

Since the default will be either 0 or date(0,0,0), the sort that does not apply will have no impact.

-LB