Sorting Based On Parameter

[fbermudez]

Does anyone have an example of sorting based on a parameter field.

I would like the user to select how the report will be sorted. Either by Customer, or by Region, or by Sales, etc...

The book Crystal Reports Professional Results has example that I just do not understand.

Any help is greatly appreciated. Thanks!

 

[lbass]

Create a discrete, string parameter {?Sort} and set the defaults to: Customer, Region, Sales.

Then create a formula {@Sort}:

if {?Sort} = "Customer" then {table.custname} else
if {?Sort} = "Region" then {table.region} else
if {?Sort} = "Sales" then totext({table.salesamount},0,"&quot

Substitute your own field names, and make sure that all formula results are converted to strings. Go to Report->Sort Records and add {@Sort} as the sort field.

-LB