Sort fields in Crystal Report - Please HELP 1

[amutinu]

Hi All,
I am developing a crystal report from a view. The report displays fine but now i want the user to have the ability to sort the report by the column headers (like FirstName, LastName) by clicking on the column headers.

Can this be done? if yes, can someone please share with me what the steps are?

I really appreciate your response,

thanks

 

[paulmarr]

amutinu,

No, unfortunately that can't be done. The report will be sorted by the report designer - ie. clicking on a field and hitting the a-z button.

You can, however, give the user control, by grouping your data on a formula based on a parameter.

For example: You could have a parameter asking the user to enter a field from a drop down box to sort by. The formula you group by will be something like:

if {?parameter} = {db.field1} then
{db.field1}
else if {?parameter} = {db.field2} then
{db.field2}
else
{db.field3}

Hope this helps you.

Cheers,

paulmarr@arcom.com.au