Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of JestersGrind
JestersGrind
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of csdparts
csdparts

ASKER

How to create linked server in SQL to the AS400 ?? Can U give an example? Please help me...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial