Menu
I created a matrix report. The report looks like this:
I want to sort the output so the region with highest sales should come on top.
e.g. From the above report South should show on top then West, Central and East.
How can this be done in SSRS (2008R2)?
609
Sorting in SSRS example Please select the Sorting tab. Sort by: It will allow you to select the available Column from the Dataset. Or we can create our own Expression by clicking the fx button. For instance, If you want to sort the data by Product Name, then select that column name.
In report design view, right-click the text box in the group header row to which you want to add an interactive sort button, and then click Text Box Properties. Click Interactive Sorting. Select Enable interactive sorting on this text box.
To apply SSRS sorting, Select the Top Left Corner of the report, and Right-click on it to open a context menu. Please select the Tablix Properties.. option from it Once we click on the Tablix Properties.. option, a new Tablix Properties window will be opened. Please select the Sorting tab.
You can create a conditional column in Query Editor which defines sort orders for the field you drag to Columns section of the Matrix visual. Then click the field in your table, choose "Sort by column" to sort the field by the conditional column.
Add an interactive sort button that enables a user to click one sort button and sort multiple data regions. When you create an interactive sort button, you can specify whether to synchronize the sort for multiple data regions based on the same report dataset.
Sorting a Top-Level Parent Row Group for a Table or Matrix. Add an interactive sort button to a column header to enable a user to click the column header and sort the parent group rows in a table or matrix by the value displayed in that column. The order of child groups remains unchanged.
You should just need to change your sort expression in the Group Row properties. Should be something like
=Sum(Fields!YourFieldHere.Value)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
