SSRS Tutorial 84 - Implement Interactive Sorting on Matrix in SSRS Report

In this video series of SSRS Tutorial, we will learn how to Implement Interactive Sorting on Rows and Columns in Matrix.

You will learn

How to create Matrix Report in SSRS
How to Enable Interactive Sorting on Rows Group
How to Enable Interactive Sorting on Columns Groups
Some Experiments and outcomes for Interactive Sorting on Matrix

Visit our website to check out SSRS Tutorial Step by Step

[aniruddhaacharya]

Solution for sorting
1. Add parameter for Asc and Desc
2. Right click on cell - ProductName -- Column Group -- Group properties -- Sorting -- Expression -- Switch (Fields! ProductName.Value ="Cell Phone", 1, ProductName.Value ="Computer", 2, ProductName.Value ="Laptop", 3,
ProductName.Value ="TV", 4)

Now this is expression for Asc likewise using IIF you can type for Desc

Hope it helps

[bobchannell]

The way you say from sounds like froma, which makes me think you're Italian. I I hear a lot of a's at the end of words you speak that sounds Italian to me. I know you're from Pakistan though. Do many people from Pakistan say English words like this? Just curious. I like your videos, and I've subscribed to your'e channel. I think this one about creating interactive sorting in a matrix will help me finish a project tomorrow. The project actually is to add interactive sorting to a tablex. If I've spelled that right. When I left work for the day yesterday, I got the group to sort properly, but not the detail rows. - This was interesting, but it' not really the answer to my problem. The last video did give me an idea though. I'll probably try to sort by an expression. I'm hoping that works, because the details are actually like this. [first(column name)] Anyway, I hope I can figure out out. Thank You for making these videos.