What are the different ways to sort your report data? What is interactive sort - SSRS Interview Questions and Answers

There are three different ways to sort your data in ssrs report

1) Sort Data in DataSet Query

You can sort the data in your query that you are using for DataSet definition. Let's say we would like to sort the data by Region, we can use below query in our DataSet. If you are using Stored Procedure you can use Order by clause in your Select query inside Stored Procedure.


2)  Sorting Data with Expressions

You can sort the data in report after retrieved from data source. You can enabling sorting on Tablix,group or detail group. Sorting can be enable on Tablix, Matrix,List, Chart,Gauge etc. Click the properties of Report Item and if you see Sorting listed in properties you can enable sorting on those report items.

Here is example how you can enable sorting on tablix
Enable Sorting on Tablix in SSRS Report - SSRS Interview Questions and Answers

3) Interactive Sorting :

you provide button on columns for the users to choose the sort order. 
here are the steps to enable Interactive Sorting in SSRS Report
i) Right Click on Column and go to Text Box Properties as shown below
 Enable Interactive Sorting in SSRS Report Column- SSRS Interview Questions & Answers

ii) In Text Box Properties go to Interactive Sorting Tab. Click on Enable interactive sorting on the text box. In next step you can choose either you would like to sort details or on Group. Finally you have to choose the Column which you would like to sort. You have option to write expressions.

How to Enable Interactive Sorting in SSRS Report - SSRS Interview Questions and Answers


Hit Ok. Now once you preview report you will see a Interactive Sorting Button in Column as shown below.


2 comments:

  1. Hello. I am sure that for a person who plans to treat and take cannabis products, the most important factor is still the reliability of the manufacturer and the high quality of CBD. Personally, I have chosen one of the great brands in the US that makes high quality CBD oil https://www.cornbreadhemp.com/collections/full-spectrum-cbd-oil, and I think that many forum members will read this to make the right decision to get rid of many health problems.

    ReplyDelete
  2. At this time, I want to tell you about my experience of a remedy that improves the condition of the body. I found it this year and delta 8 as it helped me not to feel pain, stress and feel better. I also sleep better and now I can fall asleep quickly and fall asleep well. If you need the same remedy, you can try to turn to this service.

    ReplyDelete