CODEWITHSUNDEEP
sql-serverreporting-servicesreportingservices-2000
Dave Mateer
Dave Mateer

Reputation: 6636

Reporting Services 2000 - email different report to many people

Reporting Services 2000 Standard Edition (currently RTM but hope to have SP2 soon).

I have a report which takes in a parameter - PlantID

I'd like to email a pdf of this report every month to the 80 different plant managers

So I have a table:

PlantID    ManagerEmail
1          [email protected]
2          [email protected]
3          [email protected]

I can currently setup a subscription to email a report to multiple users each month (which uses the SQL agent).

However I want to specify the input parameter of the report (PlantID) to the recipient of the email (ManagerEmail).

Ideas on how to do this? My current thought is to build a C# app which calls the URL of the RS with the correct input parameter in it. Then gets the pdf back, then emails from C#.

Many thanks

Upvotes: 1

Views: 328

Answers (2)

Erick B
Erick B

Reputation: 1272

A Data-Driven Subscription would be the ideal answer, but I see that Data-Driven Subscriptions are not available in RS 2000 Standard.

This Article discusses how to use a stored procedure to tweak a Reporting Services subscription and insert your own values into the respective fields.

Upvotes: 1

Jared
Jared

Reputation: 7243

That would be my first thought on how to do it also.

You might also be able to set up a scheduled stored proc to execute it for you, but that's more of a guess than an experienced suggestion.

Upvotes: 0

Related Questions