Interactive Sorting For SSRS Report

Introduction

This article shows how to use interactive sorting for a SSRS report.

Create a Report Server Project as in Figure 1.

 
Figure 1: Report Server Project

Add a Data Source  as in Figure 2.

 
Figure 2: Data Source

Add a dataset  as in Figure 3.

 
Figure 3: Shared Dataset

Add a report item  as in Figures 4 and 5.

 
Figure 4: Report item
 

Figure 5: Insert table

Choose the Data Source as in Figure 6.

 
Figure 6: Datasource

Set up the table properties as in Figures 7 and 8.

 
Figure 7: TableProperties
 
 
Figure 8: Interactive Sorting

The output of the report is as in Figure 9.

 
Figure 9: Sorting

Summary

In this article we saw how to use interactive sorting for SSRS report.