hi
yes you can by a parameter
---------------
1. Create a parameter with 2 default values in the picklist: Descending and Ascending.
NOTE:
In Crystal Reports version 5 or 6, it is not possible to have a pick a parameter value from a list. The user must enter a specific value, guided by the prompting text. For example : To Sort in Ascending order type A, to sort in Descending order type D.
On the 'Insert' menu, click 'Parameter', then click 'New'.
Type the name and prompting text for the parameter in the corresponding boxes.
In the 'Type' box, click 'String'.
Click 'Set Default'.
In the 'Value to add' box, type 'Descending' then click '>' to move it to the 'Default Values' list.
Repeat the above step for 'Ascending'.
Click 'OK', then click 'OK' again to return to the report.
2. Create 2 formulas based on the field you want to change the sort direction on:
On the 'Insert' menu, click 'Formula', then click 'New'.
Create this formula:
@Asc
If {?Parameter} = "Ascending" then {DatabaseField}
Save this formula and close the Formula Editor. This brings you back to the Formula tab of the Insert Fields dialog box.
Click 'New' and create this formula:
@Des
If {?Parameter} = "Descending" then {DatabaseField}
Save this formula and close the Formula Editor.
Click 'Close' to return to the report.
4. Sort the report based on these two formulas.
On the 'Report' menu, click 'Sort Records'.
In the 'Report Fields' list, click {@Asc} and move it to the 'Sort Fields' list.
Under 'Sort Direction', click 'Ascending'.
In the 'Report Fields' list, click {@Des} and move it to the 'Sort Fields' list.
Under 'Sort Direction', click 'Descending'.
Click 'OK' to return to the report.
Once you preview the report you will be prompted to select a parameter value, which will determine how the report is sorted.
---------------------------
cheers
pgtek