how to send email in ssrs report pdf automatically

Question

0.00/5 (No votes)

See more:

Hi All,
I have to send ssrs report pdf through email in daily for the getting status of the orders of report.Can u please let u know.

Posted 24-Jan-13 22:56pm

venkatgopal.mandada

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2013-01-24T23:20:00

Solution 1

I have been working on the same task
I found below blog useful for me . read it

http://36chambers.wordpress.com/2011/06/03/reporting-services-2008-creating-reports-programmatically-without-using-a-reportviewer/[^]

Below code is for sending report generate by above code as a attachment to mail

http://vb.net-informations.com/communications/vb.net_smtp_mail.htm[^]

Read below blog for how to send mail using sql server

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/[^]

Hope this helps if yes then accept and vote this solution otherwise revert back with your queries
--RDB

Posted 24-Jan-13 23:20pm

RDBurmon

Updated 1-Feb-13 2:04am

v2

Comments

venkatgopal.mandada 29-Jan-13 4:45am

Thank u for giving reply for the above answer.What I am asking is i have to sent email with in the particular interval of using ssrs report Through subscription.

RDBurmon 29-Jan-13 5:47am

Then do one thing

1) Create SSIS package to export ssrs report to PDF {Search on google you will find tons of link Very popular topic on google}
2) Schedule SSIS package on SQL job {do googling}
3) Send exported pdf document to mail using database mail {Do googleing}

Accept and vote if helps otherwise revert back with queries
--RDB

venkatgopal.mandada 1-Feb-13 1:13am

ok Thank u .Then how can i send email....

venkatgopal.mandada 1-Feb-13 1:15am

Can you send a link export to pdf through ssis packages...

RDBurmon 1-Feb-13 1:47am

Read this from exporting ssrs report in pdf using ssis

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/7adb2621-f95a-4abf-9b41-141d9caab298

venkatgopal.mandada 1-Feb-13 3:09am

Thank u RahulDhoble.Now i want schedule single Report Pdf send to multiple users in ssrs is it possible through ssrs...

RDBurmon 1-Feb-13 7:35am

As you have exported this into PDF on some drive . Then as using SQL Database mail you can mail this pdf as attachment to multiple users and you can schedule this job to run after your package run

venkatgopal.mandada 1-Feb-13 7:55am

By using sql database also we can send email..is it possible?Then how can it is tell me..Thank in advance...

RDBurmon 1-Feb-13 8:04am

Yes we can . See my updated solution

venkatgopal.mandada 1-Feb-13 8:13am

using Database its ok. sending email.But it want to send email from subscription after that i have to scheduel on it.... for every user.Without any subscripiton in report manager can i send through c sharp is it possible using c sharp.net .

RDBurmon 1-Feb-13 8:17am

Yes you can . Reread blog from link given by me in above solution.
Or search on google how to export ssrs reoprt using Querystring(Providing parameter and report name in the link itself)