Export Crystal reports and printing

Question

i have to export my reports to pdf at the clients browsers for printing and donwload in c#

chidujoshi · Answer

JocDev, Here is the code to export the data into excel format. I have not tried pdf format though. But, this code will surely help you. Enjoy!!! protected ReportDocument MyReport = new ReportDocument(); // Your report name here(Mine was Batch_View.rpt) protected Batch_View mylist = new Batch_View(); private void cmdExport_Click(object sender, System.EventArgs e) { string strExportFile = Server.MapPath(".") + "/temp.xls"; // Which report ??? MyReport.Load(Server.MapPath("Batch View.rpt")); MyReport.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; MyReport.ExportOptions.ExportFormatType = ExportFormatType.Excel; DiskFileDestinationOptions objOptions = new DiskFileDestinationOptions(); objOptions.DiskFileName = strExportFile; MyReport.ExportOptions.DestinationOptions = objOptions; MyReport.Export(); Response.ContentType="application/ms-excel"; // Default File Name Response.AppendHeader( "content-disposition","attachment; filename=Report.xls"); // Path where the file exists FileStream sourceFile = new FileStream(strExportFile, FileMode.Open); long FileSize; FileSize = sourceFile.Length; byte[] getContent = new byte[(int)FileSize]; sourceFile.Read(getContent, 0, (int)sourceFile.Length); sourceFile.Close(); Response.BinaryWrite(getContent); File.Delete(strExportFile); } private void cmdPrint_Click(object sender, System.EventArgs e) { int intPageCount = mylist.FormatEngine.GetLastPageNumber(new CrystalDecisions.Shared.ReportPageRequestContext()); mylist.PrintToPrinter(1,false,1,intPageCount); }

Export Crystal reports and printing

Answers (1)