Hi, I am trying to sort a matrix using three columns in a particular order. However the row groups are not displayed in that order. For example I want to sort as Order by 2,3,1 and the row groups are displayed as: 1,2,3 It keeps sorting on the order the row groups are displayed (left to right) no matter what sorting expression I put in. Can someone help. Thanks in advance. -SG

dint you put the expression on column grouping for sorting Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

It still follows the rowgroup order for sorting from left to right.

Hi SVG24, From your information, I get that you want to sort the data by 2,3,1 order rather than 1,2,3 right? If so please follow these steps to achieve your requirement: 1. Right-click the Category datafield on the X-Axis. 2. Then select Properties, switch to Sorting tab. 3. Type in below expression in the textbox =IIF(Fields! YourDataField.Value=3, 2,IIF(Fields! YourDataField.Value=1, 3, 1)) 4. To Direction, please select Ascending. 5. Click OK Preview the report, you will see the value on the chart is order by 2,3,1 not 1,2,3 Thanks, Challen Fu