Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can i mail report output automatic in SQL reporting service?

Posted on 2009-05-05
2
Medium Priority
?
498 Views
Last Modified: 2012-05-06
I have create a report .rdl and deploy it in SQL reporting server.

How can i directly email the output of report to the fix given email address? I don't want to run report and export to excel or pdf.

Is there any way by which i can achieve this?
0
Comment
Question by:ferik
2 Comments
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 1050 total points
ID: 24311657
If you configured Mail in Reporting Services then you can go to the Report and schedule an Email Subscription.
Report-Subscription.png
0
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 450 total points
ID: 24315267

I'd like to note that the datasource used for the report must have a username & password saved.  You can't use a datasource w/ windows authentication on a subscription report
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question