Add/Remove columns in rdlc at runtime

Eyval, I have found my response in this link[^]

Here I found good example of loading RDLC in runtime, we may also hide columns from codebehind

http://www.mixedresponse.com/Blog/Details/10

Hi
I had the same situation as like you. So what exactly i have done is:

Create a static RDLC with 25 columns(u may extend).

Hide all the columns by default.

Load the RDLC as XML.

Now collected my run time table columns and replaced the static columns of the RDLC with orginal table columns
example
COl1,COl2,Col3,......Col 25
after getting xml
Col1 should replaced with FirstName, then set as visible
Col2 should replace with LastName, then set as visible
Col3 should replace with Adddresss, then set as visible
like this make the changes for columns.
Similary make a loop for the data of orginal table put the data in the newly created columns,
Now your RDLC will be ready with new columns and fresh data

Now show this report to end user.

One important event you need to implement is RDLC_Unload() in which you need to Reset all your changes ie set Col1,Col2....Col25 remove data etc)

Now check this with the following link
http://lbrtdotnet.wordpress.com/2011/08/12/reporting-services-creating-a-dynamic-column-tablix-report-using-rdl-generator

Thanks