Hi, I have a report that has four Interactive sorting columns. I need to label the column's name being sorted on the header area. That is, If a user select sorting on column A, then column A's name will be labeled on report's header. Is that possible? I'm using SSRS 2008 R2. Thanks.

Hi, From your description, I’m afraid it is hard to get the status of the built-in interactive sorting. However, one possible workaround is to add a customized interactive sorting. In this way, we are able to get the sorting column name. For example, there are 3 columns (ProductKey, ProductName and StandardCost) in the table. In order to add a customized interactive sorting, please refer to the steps below: 1. Add a parameter to the report by the following configuration Name: Sort Data type: Text Allow null value: Checked Visibility: Hidden 2. Right click the column header textbox of the first column (ProductKey), and select Text Box Properties… 3. In the Text Box Properties dialog, select the Action in the left list. 4. Select the “Go to report” option, and then select the same report in the “Specify a report” dropdown list. Click Add to add a parameter. Specify “Sort” in the Name field and “ProductKey” in the Value field. 5. Repeat step 2 to step 4 to add action to the column header of the second and third column. 6. Right click the handle of the table and select Tablix Properties… 7. Select the Soring tab, and click Add. 8. In the “Sort by” dropdown list, specify the expression like =Switch( Parameters!Sort.Value="ProductKey",Fields!ProductKey.Value, Parameters!Sort.Value="ProductName",Fields!ProductName.Value, Parameters!Sort.Value="StandardCost",Fields!StandardCost.Value ) After created the customized interactive sorting, we can add the Sort parameter to the report header for displaying the sort status. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you