csdparts
asked on
How to use multiple datasource (sqlserver & DB2/400) in a single report in reporting service ?
I have created one dataset using sql server datasource and another dataset using DB2/400. I have to link these datasets and to populate data from both datasets in a single report in Reporting service. It is possible to take fileds from one dataset and fields of another dataset using aggregate functions. But my requirement is to link both datasets and fetch data from both daatsets in detail section( in one dataregion ) of the report itself. Please give me a solution.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER