SSRS: How can I run dataset1 first in datasource1 then run dataset2 in datasource2?

Question

I have 2 data source(db1, db2) and 2 dataset. 2 dataset are store procedure from each data source.<br /> Dataset1 must run first to create a table for dataset 2 to update and show (dataset 1 will show result too).<br /> Cause the data of the table must base on some table in DB1, the store procedure will create a table to db2 by using link server.<br /> I have search online and tried "single transaction" in data source, but it show error in data set 1 with no detail.<br /> Is there anyway to do it? cause I want to generate an excel with 2 sheet for this result.

Answer 1

Since you work on two databases, after you run the first data set, you need make connection to DB2, then run data set 2. then combine two results.