Using Different MSSQL tables to populate table in RDLC report.

Hi,

i just wanted to populate rdlc report table with different MSSQL tables depending on the required condition.

N.B the structure of all sql tables and table in rdlc report is same.

Thanks

Bilal

Thread moved to Reporting as you should get better answers here

Haven't used rdlc in a long time but I think the solution would be to create the report using a Dataset as the datasource. This way you can load the dataset from any database tables that have the correct fields. Here's a start http://msdn.microsoft.com/en-us/library/ms252094.aspx Also, Google "create rdlc report using dataset", there's lots of info.

I have no idea what RDLC is...

with that said, I would normally use a VIEW for something like this - so the "source" of data could be any table.