Through the blog, just wanted to share a learning regarding a “Matrix” control available in SSRS.
Using this control, we can mimic the functionality of “Pivot Column” which is provided in Power Query feature of Excel.
What is control basically does, it that it allows us to dynamically add columns instead of being based upon the columns available in results of a dataset.
For example, consider a scenario, wherein we need to make a Report on Survey’s in Voice of Customer such that we capture the questions present in the survey as different columns, and in rows we show the responses given by different people on the rows, we can use this control. Please note that questions are dynamic and will be different in each survey and are not present as fields on the survey.
In the mentioned below screenshot, i have just added the matrix control, and in the column groups i have specified the Question, while in the data i have added the response for that question present in each survey response.
Mentioned below screenshot shows the output of the SSRS report with the Matrix control showing the questions in columns