sort all data of dataset using interactive sorting in SSRS

In SSRS , interactive sorting is typically applied at the page level, meaning it sorts data within the current page of the report. 
However, if you want to sort all data in the dataset (across all pages) using interactive sorting, you need to implement a workaround since SSRS does not natively support sorting the entire dataset interactively.

First you need to add interactive sorting to the column header :
1. Open your SSRS report in Visual Studio or Report Builder.
2. Select the column header textbox where you want to enable interactive sorting.
3. Right-click the textbox and select Properties.
4. Go to the Interactive Sorting tab.
5. Enable Enable interactive sorting on this textbox.
6. Choose the dataset and the field you want to sort by.

To sort the entire dataset, you need to pass a parameter to the dataset query that determines the sort order. Here's how:

1. Create a report parameter (SortOrder) to store the sort direction (ASC or DESC).
2. Modify the dataset query to include an ORDER BY clause that uses the parameter value. For example:
   

SELECT * FROM YourTable
   ORDER BY 
       CASE WHEN @SortOrder = 'ASC' THEN YourColumn END ASC,
       CASE WHEN @SortOrder = 'DESC' THEN YourColumn END DESC

3. Set the default value of the SortOrder parameter to ASC or DESC as needed.

Then update interactive sorting to pass the parameter :
1. Go back to the interactive sorting properties of the column header.
2. In the Interactive Sorting tab, click Add under Choose what to sort.
3. Select the dataset and the field to sort by.
4. Check the option Also apply this sort to the following groups and select the appropriate group (if applicable).
5. In the Expression box for the sort order, use an expression to toggle the SortOrder parameter between ASC and DESC. For example:

=IIF(Parameters!SortOrder.Value = "ASC", "DESC", "ASC")