How to create dynamic reports in VS2005

Question

Hi All I'm using VS2005. I want to create a dynamic report (Not crystal report). I've a webform with a list of columns...now user will select the columns he want in the report and clicks a button 'Get Report'. On clicking the button..the report should be generated with the selected columns only. Can anyone help me regarding this..? Or plz tell me how to hide a column of the report (.rdlc file) programatically.. Thanks Venky

Sivaraman Dhamodaran · Answer

You should use join between the tables and then bring the columns in the select query. Then use this in the RDLC report. You can see a good Article from this Link