March 21, 2009 at 6:35 am
Hi,
I'm having two datasets in the Report, one is having XML datasource and another one is having SQL database. Now i want to show the data from XML dataset based on the value of SQL Dataaset.
Can any one having any idea.
Thanks
Manish Gupta
March 21, 2009 at 5:35 pm
Are both data sets stored in a SQL Server (e.g. SS2K5)?
If so, the easiest way would be to create a view on server side and go from there.
If not, the following link might be helpful (at least to start with).
March 22, 2009 at 11:41 pm
Hi,
XML dataset is generated using the webservice and other one is using SQL Server. I want to pass the one field from the SQL Server dataset to XML dataset. based on the parameter XML datasource will filter the records.
Thank You
Santosh Gupta
March 23, 2009 at 3:56 pm
Hi,
after doing some extended (google) research it looks like there is no way of directly joining two SSRS datasets together.
Out there in the wide wide web two options are discussed to get the data together
1) using subreports with the drawback of performance reduction and
2) join the data at the SQL Server side and connect the result to SSRS. Your XML data could be referenced in SQL Server by using OPENROWSET (Bulk). Or maybe you have a environment where a SQL Server is configured for Web access to receive the data directly.
So, coming back to your original question:
No, as to my knowledge it's not possible to join those two datasets in SSRS. Sorry.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply