Multiple Datasets from multiple Data Sources
I am working on a report (in SQL Server Reporting Services 2005) that has two data sources, one is Oracle 10g and one is DB2. I can make the connections to both data sources, and even create the datasets for each in the data tab. My problem is that one dataset needs to "feed" the parameters for the second dataset. The first dataset shows all products included in a particular catalog. The user must choose the catalog code to get all of the products (run-time parameter). The second dataset has all the costs associated with making the products. Both datasets have a relatable (join-able) field which is the product ID. I cannot figure out how to join the two datasets. When I try to put a parameter on the second dataset using the values populated from the first dataset, I get errors. Same with Filters. Does anyone know how achieve this task in SSRS 2005? Also, for reasons too complex to explain here, it is not possible to create a combined dataset at the database level (UG!!).