Home Forums Reporting Services Reporting Services How to use two different datasets (from DBs on different servers) in one SSRS Report without Linked Servers RE: How to use two different datasets (from DBs on different servers) in one SSRS Report without Linked Servers

  • If you create VIEW with the Query you mentioned (That will be your Dataset).

    Now you should be able to reference one DATASET from your Report.