CODEWITHSUNDEEP
sqlreporting-services
nairware
nairware

Reputation: 3190

SSRS Subscription with Multiple Data Sources

Using the subscription functionality of SSRS, I have automatically run reports in a scheduled manner and sent out e-mails with the results of the report. I have only done this using a single data source. My question is, can I do this while using multiple data sources?

My goal is to just run the same report across a collection of data sources, and then have all of the results from each data source get sent out in one e-mail as a subscription.

In my specific case, I just need a single row for each data source. My intent would be to form a table, with one row articulated for each data source.

Upvotes: 0

Views: 1738

Answers (1)

Adrian Torrie
Adrian Torrie

Reputation: 2844

Using the subscription functionality of SSRS, I have automatically run reports in a scheduled manner and sent out e-mails with the results of the report. I have only done this using a single data source. My question is, can I do this while using multiple data sources?

This isn't clear because a single report can only be matched to a single subscription.

My goal is to just run the same report across a collection of data sources, and then have all of the results from each data source get sent out in one e-mail as a subscription.

Do this in a single report that uses multiple data sources.

In my specific case, I just need a single row for each data source. My intent would be to form a table, with one row articulated for each data source.

Sounds like you have two options here:

  1. Use Linked Servers:
    • Linking Servers Link 1.
    • Create Linked Servers Link 2.
    • Write a query that returns a single line for each source and use UNION ALL to create a single result set/'table'.
  2. Create a report that uses the multiple data sources.
    • Have a single row table for each source and then arrange the tables to look like a single one when rendered.

Create a single subscription for your new report that combines multiple data sources.

Upvotes: 1

Related Questions