Crating .rdlc reports programmaticaly

Question

Hey

Is it possible to create a full .rdlc report completely from code? By full I mean dataset assignment, grouping etc. If not, is it possible just to change the dataset (providing that the new dataset has the new schema as the previous one). I'm asking this because I need to use multiple databases in my application, and I don't know how to do the switch because of the reports (if I make them using the wizard, I have to use predefined datasets that are created by TableAdapters, and then I have the problem of changing connection strings)? Do you have some suggestions on how to do it?
Thanks

Sam Hobbs · Answer

I think that is not the best solution. I think you can use the solution for Switching between databases in WinForms . I do not have the time to get to that now but I will.

Neven Draskovic · Answer

Thanks I'll try to use one of them

Senthilkumar · Answer

Hi Naven There are some links about dynamic .rdlc creation. This may help you bit. http://csharpshooter.blogspot.com/2007/08/revised-dynamic-rdlc-generation.html http://forums.asp.net/t/1556522.aspx/2/10 http://www.sourcecodester.com/visual-basic-net/creating-rdlc-report-programmatically.html