Avatar of csdparts
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.
SSRSDB Reporting ToolsMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
JestersGrind

8/22/2022 - Mon