Hi, In one of my reports, there is a requirement to provide interactive sort functionality on all the columns of the matrix report. (Reporting Services 2005). I was successful in implementing the interactive sort on the row groupings, but was unable to do the same on the column groupings. For example , I have the following : Product Name 2007 2008 Actual Forecast Actual Forecast Bikes 40 50 45 50 Cars 60 62 30 40 Trucks 20 25 55 60 This is a matrix layout, Product Name is on row group and Year is on Column group. Actual and Forecast are the columns present under the Year Column group. I could implement the interactive sort on Product Name(row group) but not on Actual and Forecast(columns under the column group). Hope I am clear. Please let me know if someone has a solution for the interactive sort on columns in Matrix layout. Thanks in Advance, Regards,Dinesh.

Hi Dinesh, Please make sure you carry out the column sort by the instruction below. Open Matrix Properties dialog box. Switch to "Groups" tab. Select "Product Name" field in the Rows list and click "Edit". In Grouping and Sorting Properties dialog box, go to "Sorting" tab and select "Product Name"field from the drop down list. Note that the expression on sorting should be the same as that on row group. Click "OK". Hopefully this helps. Thanks.

I'm having the same problem, following your instructions sorts the result set initially but does not help with the interactive sort function. Is it even possible to add an interactive sort to the column headers?

U can do this... Go to ur Column or Row Group header value then right click go to properties in the interactive sort tablethen (Add the Interactive Sort) this can be based on any of the item in the dataset.U can view this only in Excel rendering and Reports. I have tested this.

Hi, You can solve this problem using as follows: 1: Right click on your matrix | select Properties and | choose the Groups Tab: You will see the Rows and Columns details. What you need here is the name of the row in your matrix. it will be like matrix1_field_name. take the name and close the properties window. Note: to select your matrix, right click inside any cell of your matrix and choose Select 'Matrix1'. If you want you can edit the name of you row, and use the new name in step 3|C. 2: Choose where you want to put the interactive sort button. you can choose the left corner or the header field of thesubtotal column (To view the subtotal column, right click on the header field of your column and choose subtotal,then right click on that and choose properties. 3: Choose the Interactive Sort tab, you will see the following details: A> Add an interactive sort action to this textbox Tick the Add an interactive sort action to this textbox. B> Data Region or Grouping to Sort: Tick the Choose date region or grouping radio button, and from the drop down choose 'Matrix1' C> Evaluate sort expression in this scope: Tick the Choose data region or grouping radio button, and put the name of the row in you matrix that you took in step 1. let me know if you have any questions mohdsamaha at hotmail dot com please the video http://www.4shared.com/file/67540028/cb9268bf/SSRS2005_Matrix_Interactive_Sorting.html

Hi, Me too had a problem in doing sorting in Matrix...now its solved..thank you :-) Rgds, artbria

Thanks to this post,very detailedanswer mohammadSamaha - Posted on Monday, 20 October 2008 (using the same example in the first post)I had the same problem, and now following the instruction, I can do interactive sort by putting the sort button in textbox "Product Name" and evaluating the value of first Column (in this case, I assume the sort expression would be =Fields!ProductName.value), so now I can sort them into Bikes, Cars, Trucks or Trucks,Cars, Bikes. Product Name 2007 2008 Actual Forecast Actual Forecast Bikes 40 50 45 50 Cars 60 62 30 40 Trucks 20 25 55 60However I still can't do interactive sort by putting the sort button in textbox "Product Name" and evaluating the value of Actual. For example, the code in the column Actulal is =sum(Fields!Actual.value). So I changed the Sort Expression from =Fields!ProductName.valueto be=sum(Fields!Actual.value), then anything else exactly the same as sorting by Product Name.It dosn't work, it dosn't give me the order of 20, 40, 60 or 60, 40, 20 in 2007. Also, I have tried to right click on textbox "Actual", but I can't see subtotal asmohammadSamaha's post advised.I was wanting to put a sort button in the subtotal headers of Actual and Forecast.Ideally, I want to put a sort button in Actual and Forecast to sort the according value. But this seems impossible by reading a lot of online resources. If I can't, at least I want to have the buttons all put to the corner text box "product name" but it seems not possible to have more than 1 sort button in one text box.All responses are welcome, including your try-and-error experience. Thank you

Hi, I'm having a similar issue. I would like to be able to sort on the numeric values in the column, by clicking a sort button in the column header. I have attempted many different configurations of the Interactive Sorting but it doesn't seem to work no matter what I try. There seems to be a lot of confusion out there as to whether or not this is actually even possible. Can anyone shed any light? I am using SSRS 2008. Thanks

Hi, For example , The output should be as below. Product Name 2007 2008 Actual Forecast Actual Forecast Bikes 20 25 30 40 Cars 40 50 45 50 Trucks 20 62 55 60 Any idea how to implement the interactive sort for this? Thanks