Export crystal report to Excel Data Only through program

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

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

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Imtiyaz Ansari12y ago
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);

}

}