Click here to Skip to main content
15,893,381 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
i want to export crystal report to pdf i want to display i am getting error Invalid report file path. while exporting
i am using this code


C#
protected void Button2_Click(object sender, EventArgs e)
   {
       string query;

       //    string q = Request.QueryString["q"];
       con.Open();
       query = "select * from Tech_data where id ='" + TextBox1.Text + "'";
       cmd = new SqlCommand(query, con);
       da = new SqlDataAdapter(cmd);
       dt.Clear();
       da.Fill(dt);
       if (dt.Rows.Count > 0)
       {

          // ReportDocument Report = new ReportDocument();
           cryRpt.Load(Server.MapPath("~/CrystalReport.rpt"));
           cryRpt.SetDataSource(dt);
           //query = "select * from Tech_data where id ='" + TextBox1.Text + "'";
           //cmd = new SqlCommand(query, con);
           //da = new SqlDataAdapter(cmd);
           //dt1.Clear();
           //da.Fill(dt1);
           cryRpt.SetDatabaseLogon("sa", "123456789", @"TRAINING-ROOM-8", "Technical_sup");
           CrystalReportViewer1.ReportSource = cryRpt;
           CrystalReportViewer1.DataBind();
           CrystalReportViewer1.RefreshReport();
       }
       con.Close();
   }
   protected void btnShow_Click(object sender, EventArgs e)
   {
       ExportOptions CrExportOptions;
       DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
       PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
       CrDiskFileDestinationOptions.DiskFileName = pdfFile;
       CrExportOptions = cryRpt.ExportOptions;    <<<--- ERROR
       CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
       CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
       CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
       CrExportOptions.FormatOptions = CrFormatTypeOptions;
       cryRpt.Export();
   }
Posted

1 solution

 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900