Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sending Emails based on Report Data? Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 8:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 9:26 AM
Points: 5, Visits: 4
Is it possible, in SSRS 2008 (not R2), to create a single or periodic snapshot report and have emails generated based on data within that report? For example, if a given numeric field is greater than, say, "80", send a copy of the report or any other custom email to selected addresses...

Have any of you seen another application that can do the "automatically"?

Thank you for your assistance.
Post #1432700
Posted Tuesday, March 19, 2013 9:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
This sounds like a data driven subscription. http://msdn.microsoft.com/en-us/library/ms159762.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1432712
Posted Tuesday, March 19, 2013 9:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 9:26 AM
Points: 5, Visits: 4
Sean,

Thanks for the quick response.

May I assume from your answer that this capability does not exist in SSRS 2008; but requires SSRS 2012? And actually, 2012 plus SharePoint (see "Data Alerts", http://msdn.microsoft.com/en-us/library/gg492252.aspx)? I have read about that new capability.

However, I was hoping there might be a way to accomplish this using the current infrastructure as my team doesn't have the budget to add a new server and the existing server is used by many other teams.

Is there any sort of "workaround", other than hiring a temp to read the reports and send out emails?

Post #1432734
Posted Tuesday, March 19, 2013 9:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
john_t_bailey (3/19/2013)
Sean,

Thanks for the quick response.

May I assume from your answer that this capability does not exist in SSRS 2008; but requires SSRS 2012? And actually, 2012 plus SharePoint (see "Data Alerts", http://msdn.microsoft.com/en-us/library/gg492252.aspx)? I have read about that new capability.

However, I was hoping there might be a way to accomplish this using the current infrastructure as my team doesn't have the budget to add a new server and the existing server is used by many other teams.

Is there any sort of "workaround", other than hiring a temp to read the reports and send out emails?



No the article I referenced is the MSDN topic. There is dropdown at the top to get version specific information. This feature started with SQL 2005.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1432741
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse