Customized Sorting Using Parameter

Let’s give some customize option to our end user to sort the report output as per their choice.

Let’s go through with the following steps:

Step1. Create a new parameter and list out all the field names under Available Values property of the parameter. Specify field names under Label as you want to show to your end user and keep the value same as in your database field by comma separator and sorting order. Refer Image-1

 

Image-1

Step2. Now we need to write our query in a dynamic fashion in dataset. So open your dataset properties and under query window, specify your query.

Refer Image-2

 

Image-2

Step3. Now put following expression at the end of your dataset query. Refer Image-3

=+IIF(Parameters!p_sortby.Value=“None”,” “,“Order by “+Parameters!p_sortby.Value)

 

Image-3

Downloadsample Report