SSRS Report to Create Dynamic Columns

May 6 2021 5:36 AM

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.

When 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?

Answers (1)

How to create a 'list within a list' using a sql temp table

Select*from emp ( I want to run this query in 20 databases?)