Reporting Services 2000 - email different report to many people

Question

Hi

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

Answer 1

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.

Answer 2

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.