Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.