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
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
Make the user to retrieve an incoming message to their e-mail account containing a report document once in a month.

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

*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


Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 475, Visits: 915
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