Binding RDLC report through code behind dynamically..

Question

In our application we need to display some columns(custom fields) dynamically if the particular user have any extra columns(custom fields).

We are able to fetch these fields from DB but unable to find out.. how to Add these columns dynamically to the Existing Report?

New to RDLC ...please give any suggestions.

Iftikar Hussain · Answer

can you give some example? Regards Iftikar

lakshmi sowmya · Answer

thanks I have gone through all the links...but what our requirement is we need to dynamically bind columns to RDLC..

Sanjeeb Lenka · Answer

check this link may help you http://www.sqlservergeeks.com/blogs/AmitK/sql-server-bi/54/sql-server-how-to-handle-dynamic-column-report-in-ssrs http://www.codeproject.com/Tips/574957/Using-SSRS-Matrix-Control-to-Generate-Columns-Dyna http://www.codeproject.com/Articles/11254/SQL-Reporting-Services-with-Dynamic-Column-Reports http://forums.asp.net/t/1453680.aspx/1

Iftikar Hussain · Answer

Hi You can use column Visibility option to show or hide a column depend on condition. I believe you are selecting all columns for RDLC. Refer the below link http://www.bidn.com/blogs/mikedavis/ssis/816/ssrs-hide-or-show-some-or-all-columns-on-a-report Let me know if you need any more help Regards Iftikar