I have a column called amount, i want to sort it in descending order. i am using SSRS 2005 .can someone please help me...is there a way i can sort this in report...msmustard

In the Table properties, go to Sorting tab and add a sorting condition on the amount column. Regards Manoj ~Mark as Answer if found correct

Hi, 1. Go to detail Group property 2. Click on Sorting . 3. Click on Add 4. Select your desired column (Set A-Z for ASC or Z-A for Desc) Hope this will help you !!! Sanjeewan

it gives me option of ascending/descending in drop down which i selected but it is not sorting. i right clicked on the group , then properties which took me to a grouping and sorting window, where in sorting i added my field =fields!amount.value and in the drop down selected descending. but it is not sorting ...Please helpmsmustard

i am using 2005 versionmsmustard

Hi msmustard, If you are using Table control in SSRS 2005, please refer to this same thread I have handled before http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/42fbe015-c462-4a25-9316-e03192d7c626 If you are using the Matrix control, please refer to this thread http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/432659aa-a5da-4f8f-ada3-6682ef38c760 Thanks,Challen Fu TechNet Community Support