I want to query the row values as Column in SQL

I have a query to result in the below data from DB

But actually, I want to get the data as

Is there any way we can do this the SSRS? How can I do this? really stuck

Answer

You can do this easily in SSRS without changing your dataset.

1. Add a Matrix control to your report
2. Drag the Assignee field to the Rows placeholder
3. Drag the Priority_n field to the Columns placeholder
4. Drag the Count_C field to the Data placeholder

that’s it. If this does not help, let me know and I will update with sample images.