Export crystal report to Excel Data Only through program

Question

Hi All, You know in crystal report, we can export the report to excel data only mode. I just want to know, how i can achieve this through C# program. I am developing a windows form application using .net 3.5. Please assist me. I searched and tried several blog postings, but didn't work. I think using Crystal decision there's possibility of doing this, but couldn't find a good article. If you could please post any links or sample code snippets. Basically what i am trying to do here is load .rpt file from a physical path and then set locate database connections and pass some parameters then generate the report to a physical folder again with Excel Data only mode. Appreciate you valuable help on this..... Thanks, Charith

Imtiyaz Ansari · Answer

hi charith try this code protected void btnexcel_Click(object sender, ImageClickEventArgs e) { //string fname = "PersonDetails.pdf"; try { SqlDataAdapter da = new SqlDataAdapter(); voucherdetails = new VoucherDetailsLogic(); dt = new DataTable(); dt = voucherdetails.SelectVoucherEntriesDetailsbyDatewise(Convert.ToDateTime(txtfromdate.Text), Convert.ToDateTime(txttodate.Text)); ReportDocument crystalReport = new ReportDocument(); // creating object of crystal report crystalReport.Load(Server.MapPath(@"~/Reports/Accounts/Rpt_DayBook.rpt")); // path of report crystalReport.SetDataSource(dt); // binding datatable CrystalReportViewer1.ReportSource = crystalReport; crystalReport.SetParameterValue("from", Convert.ToDateTime(txtfromdate.Text)); crystalReport.SetParameterValue("to", Convert.ToDateTime(txttodate.Text)); crystalReport.ExportToHttpResponse (CrystalDecisions.Shared.ExportFormatType.ExcelRecord, Response, true, "Reports"); } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message + "');", true); } }

Export crystal report to Excel Data Only through program

Answers (1)