I have a Crystal report that I want to sort alpha or numeric order and also have 3 sort keys for sorting on data headings. If I change the sortdirection in C# code then the sort keys on headings are ignored if you click them. Also, my stored procedure has logic to order by clientname or order by clientnumber - but these sorts are also ignored. In my Crystal sort keys I have 4 sort keys - one which is formula, one on clientname, one on client number and one on feeamount. The name is the first key in the crystal definitions and seems to cause report to default to alpha no matter how you select data. Is there easy way to change sort order of data returned from a stored procedure?

Hi RBath, We discuss SQL Server Reporting Services related issues in this forum. If you have any more questions about Stored Procedure and Crystal Report, I recommend you that post the question in T-SQL and Crystal forums. It is appropriate and more experts will assist you. T-SQL forum: http://social.technet.microsoft.com/Forums/en-us/transactsql/threads Crystal Report forum: http://social.msdn.microsoft.com/Forums/en-au/vscrystalreports/threads Forum Support If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com Thanks, Bin Long Please remember to mark the replies as answers if they help and unmark them if they provide no help.