Search code examples
reporting-servicesssrs-2008

Is it possible to create a dataset from another dataset in ssrs?

I have created 2 datasets that return data from a web service.

now I want to merge those two datasets in a single dataset, is it possible to create another dataset that contains those 2 merged ?

PS: you can also propose new solutions

Solution

  • Unfortunately SSRS doesn't offer that feature. One alternative is using the Lookup and LookupSet functions to use both datasets together in the report, but this is not efficient for large datasets. If the data doesn't need to be live, another option would be to create a procedure that caches the joined data in a table on a schedule and then use that table in the report. If those options aren't adequate, you may want to look at using a different reporting tool such as Excel (with web services and power query) or Tableau (if you have licenses).