SSRS : 2005
Deployed: A Simple RDL with a single input parameter(for simplicity say the parameter is City).
The requirement is to send the report to Mayor of each city. I already have a table with following info.
> Report should run at a static schedule and send reports to each mayor with their City. Currently using regular subscriptions.. which means 50 subscriptions for fifty different cities.
Every time a new city comes, automatic subscription to the Mayor Email ID. Email should not be sent if the there is no data for the city on that particular day.
View Complete Post