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.