CODEWITHSUNDEEP
reporting-services
Sahi
Sahi

Reputation: 1484

SSRS report with multiple data sources

I am not much aware of SSRS report. In my project SSRS report is generating the pdf with empty data.

Question:

My SSRS report is using two data sources say ds1 and ds2

if the query for ds1 throws a timeout error and ds2 returns the data, will it generate the SSRS report with ds2 (the fileds which use ds1 shows empty).?

Upvotes: 0

Views: 201

Answers (1)

BishNaboB
BishNaboB

Reputation: 1070

Nope. Once a dataset fails, the reporting processing fails. We have issues with an hourly log shipping to a database that knocks it offline for 5 minutes an hour - this kills reports each time.

Upvotes: 1

Related Questions