Is there a way in SSRS to send out an email, not through subscriptions, but if the budget is 75% spent then send an email notifying the Team Lead of this? Maybe a function in the Code part of the report? I'm sure there are ways through Analysis Services but we don't have that set up yet. And the server is only storing information as its entered, not as calculations, so I don't think I can set up a trigger. My boss wants it based on the reports and I feel like there should be a way to do this but am not sure how.
Any ideas or advice on how this can be accomplished would be greatly appreciated!!