Combine two Reporting Services datasets into one

Question

My report has two datasets from two different databases. And the datasets have the same columns. How can I combine these data sets into one data set

I need something like this,

SELECT A,B,C FROM DATASET1
UNION
SELECT A,B,C FROM DATASET2

Answer 1

AFAIK, in SSRS there is no equivalent to creating UNION from datasets coming from linked servers. Other similar questions get similar answers (like this one ).

LookupSet, eachother, . , SSRS.