HSI_guelph
asked on
Send an email through SSRS?
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!!
Any ideas or advice on how this can be accomplished would be greatly appreciated!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
by default you would not find this feature using SSRS and SharePoint. You may be able to creatre a custom web services to refer a columns in SSRS table and send out a alert to your team lead. But again that would require a customization and would not be possible using OOB options.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are working with SSRS 2008 but we are looking at 2012 server so the more features the newer version can provide the more likely we will upgrade. Thanks!
ASKER
I know this is beyond the scope of what SSRS was intended but sometimes we can squeeze some behaviour out of something that was never intended to be possible.