How to Combine two dataset from two different database in one dataset in SSRS?

Question

I have to fetch some data from SQL server and same kind of data need to fetch from Postgress DB and need to apply union on both DB's result then need to show in SSRS Report.

Answer 1

Hi @Bhavin Patel ,
Usually we are advised to use workarounds like SQL Server linked servers or SSIS which uses non SSRS datasources to extract data to be joined or SSRS lookup functions to achieve desired result outside of the report data retrieval stage.

We often consider the task of how to include data from disparate data sources in SSRS reports without having to look up functions, code, SSIS, or linked servers. The following links provide more possibilities: SSRS: Join data from different SSRS data sources into data set.

Detailed tutorial:
Link 1: SSRS: Merge data from different datasources into one dataset inside SSRS report.
Link 2: SSRS: Merge data from different data sources into one data set inside SSRS report using XML Connection.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Bhavin Patel
If you want to combine data from two datasets, I think you can use the Lookup function. You can refer to this link: report-builder-functions-lookup-function.
Best regards,
Aniya