How to reference two data sources in SQL Reporting Servcies
Posted on 2009-07-09
I want to create a report in SQL Reporting where my query references two shared datasources in the report.
I have created the shared data sources and individually they are working fine. lets call them Data1 and Data2.
What I want to do is something like this
Select CompanyName (Data1), Address(Data1), ContractType(Data2)
where companyID(Data1) = companyID(Data2)
the reason I need this is that some info is in data2 that is not in data1 but I need to create a report that lists it all in one table.
I am not sure if I create two shared DB Datasources if I can reference them from within the same table or do i have to create a linkserver connection from within my query.
If anybody has sample code too that would be really helpful.
Also does anybody know of any good resources for advanced SQL Reporting.