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

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?
ferikAsked:
Who is Participating?
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
If you configured Mail in Reporting Services then you can go to the Report and schedule an Email Subscription.
Report-Subscription.png
0
 
Auric1983Connect With a Mentor Commented:

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.