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: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 5:10 AM
Points: 607, Visits: 1,163
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