Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Want to sync two datasets, one has DB2 and other has SQLServer as data source to give a combined resultset. Expand / Collapse
Author
Message
Posted Friday, January 4, 2013 2:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 7, 2013 3:10 PM
Points: 2, Visits: 7
Hi,

I have two datasets in my SSRS report, first is a dataset D1 which has DB2 as data source and has 6 columns with one column userId which needs to be mapped with second dataset D2 which has SqlServer datasource and has two columns with userID and name. I need to map the corresponding userID from D1 with userID in D2 and result the Name column out of it to the result set and also if there is no name listed with a blank then print userID in the results.
Please help in achieving this and I have tried Lookup functionality but it didn't yielded expected results. i tried to pass userID from D1 as parameter to D2 to filter the records in custom code too.

Thanks for your time.

-Ram
Post #1403111
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse