Link to home
Start Free TrialLog in
Avatar of tikkub
tikkub

asked on

Combining data sets in SSRS to produce a report

I need to combine the results of two different datasets to produce a report.  I have provided a sample in the file.  Please suggest a solution using SQL Server Reporting Services.  I appreciate your help.
join-data-sets-in-ssrs-report.xlsx
SOLUTION
Avatar of Mez4343
Mez4343
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 tikkub
tikkub

ASKER

These sets are not sql results.  They are from SSAS cube.  They cannot be part of the same dataset since the granularity of some of the measures would explode the data.  I am seeking a solution with in SSRS report.  Thanks.
SOLUTION
Avatar of Jason Yousef
Jason Yousef
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
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium 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 tikkub
tikkub

ASKER

I appreciate your help.  The trick was to use the lookup function.  The thing that helped fully solve the problem was to use calculated field combining the grouping fields.  Thank you very much.