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

Bhavin Patel 1 Reputation point

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,632 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,536 Reputation points

    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,

    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.

    1 person found this answer helpful.
    0 comments No comments

  2. AniyaTang-MSFT 11,256 Reputation points Microsoft Vendor

    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,

    1 person found this answer helpful.
    0 comments No comments