Introduction

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

Create a Report Server Project as in Figure 1.

Output1.png

Figure 1: Report Server Project

Add a Data Source as in Figure 2.

Output2.png

Figure 2: Data Source

Add a dataset as in Figure 3.

Output3.png

Figure 3: Shared Dataset

Add a report item as in Figures 4 and 5.

Output4.png

Figure 4: Report item

Output5.png

Figure 5: Insert table

Choose the Data Source as in Figure 6.

Output6.png

Figure 6: Datasource

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

Output7.png&;

Figure 7: TableProperties

Output8.png

Figure 8: Interactive Sorting

The output of the report is as in Figure 9.

Output9.png

Figure 9: Sorting

Summary

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