Solved

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

Posted on 2009-05-05
2
492 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 26

Accepted Solution

by:
Chris Luttrell earned 350 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 150 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now