How to dynamically add new columns to report created with Reporting Services?

Question

User-1995655362 posted

I want to create dynamic columns in RDLC reports with the dynamic Dataset.

We are entering the columns name in a Rows in database tables (Because number of columns are not defined)and converting the rows into columns and relatd data from other tables and creating the dynamic dataset.

We have a to bind above defined dataset with RDLC file.

Is there any way to define dynamic columns in RDLC file and bind the data with it?

Piyush

Answer 1

User-8475372 posted

Yes, you can acheive this with the Matrix reports of SSRS.

http://technet.microsoft.com/en-us/library/dd207149.aspx