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

Send Message with SSRS to user's Email Acount Automatic Expand / Collapse
Author
Message
Posted Saturday, November 16, 2013 2:46 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
Goal:
Make the user to retrieve an incoming message to their e-mail account containing a report document once in a month.

Problem:
How should I do it?
I strongly believe that I need to use SQL server agent tool to make a scheduling.

Information:
*The report's document is created in SSRS.
*The document's content and data is filtered by two parameter, their full name and today's date. before you send it to their email account.
*Data source is SSAS in SSRS.
*All users is located in a domain.
*The e-mail adress and full name is located in the data mart.
Post #1514938
Posted Tuesday, November 19, 2013 4:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:12 AM
Points: 391, Visits: 704
You can achieve this through using subscriptions.

Wherever the report is located (Report Server/Sharepoint etc) go to the properties and click on Manage Subscriptions. Then click Add Subscription and configure from there.





I'm on LinkedIn
Post #1515494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse