Hi, Am Working with SSRS 2005. i need to sort columns in matrix. Interactive Sort in Table works fine. But i need it in Matrix. Somebody help me plz. Its urgent!!!! Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi, As far as I know, interactive sorting in matrices is not supported in Reporting services 2005. You can sort by group though. Try and use table if you can

Krish, Thanks for your immediate response. if interactive sort doesnt work in matrix, kindly suggest me to sort columns in matrix.Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi, Interactive sort in matrix is not supported. Only sort by Group or subtotal can be used. For sorting row/column group, right click the matrix header, click properties, and then switch to the Interactive Sort tab, and set the sorting group region and sorting expression. In Reporting Services 2005, if the row/column group is not in the drop down list of 'evaluate sort expression', you can type the row/column group name in that textbox. Here is a FAQ you can refer to: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/2baa1c0f-d23e-4cbe-b8f5-5379a7ba0846/ Thanks, Albert Ye

Hi Interactive sort in matrix is not supported. Only sort by Group can be used. for sorting column group, right click on the column create a group for the column as adjecent below group by column name from the dropdown list and delete the above row... then u will get sort on that column kindly suggest me if it is wrong Thanks, Na'Win'