How to Create Dynamic Columns in SSRS Report

Question

I need to create a SSRS report like

And I have table with 3 columns DeveloperName,TimeWorked, Date

How can I create the report and what would be sql query to fetch data? I am not asking for complete SQL query I just need some hints.

Answer 1

You can use Matrix (instead of tab-lix) to generate dynamic columns. There is no changes required in your sql query for matrix report (its just a list of DeveloperName,TimeWorked, Date) , but the Matrix control in the SSRS will handle all this. You can refer the below inks http://ssrstutorials.blogspot.in/2012/10/lesson-15-ssrs-matrix-reports.html or https://msdn.microsoft.com/en-us/library/dd207149.aspx