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); } }