SSRS Report to Create Dynamic Columns

Question

Hi all,  Need to create SSRS Report based on Roles and which Menuitems are  enabled or disabled for the Roles(Enable -0/Disable -1).I tried to display it in Matrix but couldnt get the result.  W hen i run the script that i have and got output like that .I don't know how to transformed into SSRS report.Here ,the roles are dynamic columns and based on the role creation it will vary.  How do i achieve that .Do i need to change the query based on matrix or any other way?

Satya Karki · Answer

Hi, is it necessary to show data in matrix? if not then you can show simply in table also. Are you using Microsoft Report Builder to design report? First thing, you need to understand how matrix works. Here is link that may help you to understand and designing matrix for SSRS.   https://docs.microsoft.com/en-us/sql/reporting-services/report-design/create-a-matrix-report-builder-and-ssrs?view=sql-server-ver15    As per my understanding from your requirement you can try putting Role column in  Rows of Matrix and Drag Menuitems in Columns