Search This Blog

Sunday, 14 September 2014

On Demand Sorting



Let’s give an option to our end user to sort the report output as per their choice. Not by report design.
To keep the sorting feature more rich and relevant, let’s go through with the following steps:
Step 1. 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 dataset field name. Refer Image-1
Image-1















Step 2. Now open property window of your table’s group and select Sorting. Refer Image-2


Image-2






Step 3. Now put following expression under Sort by. Refer Image-3
=Fields(Parameters!p_sortby.Value).Value
Image-3