CODEWITHSUNDEEP
sql-serverreporting-services
Tooleh
Tooleh

Reputation: 45

How to send one report to different clients using ssrs subscription

I have a report that need to be sent to different clients, I have a parameter accepting the company name, so I want to loop through my parameter and sent the report to a list of those companies and need to filter the report by company name, the user only need to see the data for his company.

Hope my question is clear. Thank you

Upvotes: 0

Views: 1623

Answers (2)

Mike
Mike

Reputation: 550

Looks like you need a Data Driven Subscription. First create a stored procedure that can be used to return EmailAddresses, CC_EmailAddresses, and BCC_EmailAddresses. Since your distribution will go to many customers and you may not want each customer to see the other customer's email address, as a good practice return the customer email addresses in the BCC_EmailAddresses, you will still however be required to have the EmailAddresses return at least one email address. Next follow the prompts to create a Data Driven Subscription. See screenshots below.

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

Upvotes: 0

R. Richards
R. Richards

Reputation: 25141

A data-driven subscription will do what you need.

https://msdn.microsoft.com/en-us/library/ms169673.aspx

Upvotes: 1

Related Questions