How to Export PDF file from Crystal report and save into Local folder of website and Send in Email Attachment

Question

0.00/5 (No votes)

See more:

Helloo,

i want to know about the Export the crystal report in PDF formate as well as direct save that export file in our website local folder and send in email as attachment via SMTP.

i tried and make PDF only but not success into save in our local folder as well as send as attachment of that PDF file into SMTP code.

 protected void Page_Init(object sender, EventArgs e)
    {
        string id;
        id = Request.QueryString["id"];
        c.setcon();
        String data = "SELECT  * from Leave_record where id=" + id + "";
        SqlDataAdapter ad1 = new SqlDataAdapter(data, c.getcon());
        DataSet ds1 = new DataSet();
        ad1.Fill(ds1);

        path = Server.MapPath("REPORTS/leave_report.rpt");
        cr = new ReportDocument();
        cr.Load(path);

        cr.SetDataSource(ds1.Tables[0]);

        string name=Server.MapPath("PDF/mitesh.pdf");
        cr.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false,name); // only show PDF file but not save in Website Folder
        CrystalReportViewer1.ReportSource = cr;
}

Please help me.

Thanks and Regards...
Mitesh

Posted 2-Jul-12 18:54pm

Mits Machhi

Updated 2-Jul-12 19:44pm

v2

Add a Solution

Comments

DamithSL 3-Jul-12 1:42am

can you show the code what you have tried so far?

2 solutions

Solution 1

Hi Mitesh,

Have a look at following links,
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-email.htm[^]
http://social.msdn.microsoft.com/Forums/eu/vscrystalreports/thread/2f37947e-34da-4459-b17b-c484da40d887[^]
http://www.c-sharpcorner.com/UploadFile/17e8f6/creating-crystal-report-and-sending-via-mail-in-Asp-Net/[^]

Hope this helps you.

Regards,
Vani

Posted 2-Jul-12 19:31pm

Vani Kulkarni

Comments

[no name] 3-Jul-12 1:36am

Dear, when i write CrExportOptions = cryRpt.ExportOptions; statement the Exportoption not showing in my code. So what can i do ?
crypt is my ReportDocument.

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)

DamithSL · Accepted Answer · 2012-07-02T19:38:00

Solution 2

May be permission issue when exporting to a folder.
You can try using temp folder as

string fileName = System.IO.Path.GetTempPath() + Guid.NewGuid().ToString() + ".pdf";

then save to temp folder

reportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, fileName);

since you have the file location you can attach that to a Email.

Posted 2-Jul-12 19:38pm

DamithSL

Updated 2-Jul-12 19:41pm

v2

Comments

[no name] 3-Jul-12 1:58am

Dear, or possible to direct send that PDF file as attachment using SMTP code without save to local folder of our website. if yes, please tell me with some code or Correct me for right way....

[no name] 3-Jul-12 2:26am

i solved it by Your Answer. Thanks Brother......

[no name] 3-Jul-12 2:26am

My 555+++++

DamithSL 3-Jul-12 2:40am

I'm glad it helped you :)

Member 10765474 6-May-14 7:00am

i tried this in my program, but it display blank page