We have a report in Reporting Services. According to results it returns we want to manage recipients.

The problem is that Reporting Services generates a list of subscribers (recipients) BEFORE the actual procedure run. If we could change the sequence of those steps we could easily solve all issues (and many others) with empty reports are being sent to our subscribers (we could dynamically remove all unnecessary addresses from subscriptions).

Basically, it’s a kind of monitoring system which should be triggered every 1-2 mins. Report contain accounts, managers of those accounts and income those accounts make to us. If income goes below specific level it should be notified to that account manager.. We want to use Reporting Services subscriptions for this task (we want to attach Excel spreadsheet into e-mails and send this e-mail to account manager).

Any ideas how it can be solved?

thanks