Thursday, 10 October 2013

SSRS: sorting in data

Question: How to apply sorting on columns in SSRS?
Answer: To apply sorting on columnss in SSRS, there are following steps -

Step 1 - Select whole table, right click on the top-left corner then select tablix properties. 

Step 2 - Once click on tablix properties a dialog will appear, select sorting vertical tab. Add filters by and corresponding order(ascending or descending)as below screen shot.

I hope it should work.

1 comment:

  1. SSRS - Column Based Drill Down Report
    A Column Drill Down report is similar to row drill report but main difference is that it’s based on the columns and will provide the additional details of the column summary. In the section, we are showing that How can we create our column based Drill Down report within few simple steps.
    SSRS - Column Based Drill Down Report