Tip: How to Export a Crystal Report to a PDF file Programmatically in ASP.NET?

Thank u very much for help

Thank u very much for help

Hi, I have a crystal report which includes 4 subreports. When I preview the report, it works fine. But when i export it into a pdf file, it has some mistake. The report in pdf file has a section repeats in many times. Anyone can help me? Thanks in advance

Hi Mahesh, This article is really helpfull. But I am stuck with passing one of the parameters, that is Response. So could you please explain what is the Response parameter in the above ExportToHttpResponse() method call? Regards, Narsing

how one can save crystalreport automatically in pdf format

Hi Mahesh, I read the about article and it works fine if the user wants to export the Report directly with out the help of Crystal Report viewer.But what should be done if the report has to get exported/Printed via Crystal Reoport Viewer ?I have the icons dispalyed for print and export on Crystal Reoport Viewer .But the page is getting refreshed when i click on any of the icons.What should i do to have the respective functionality for each icon? Regards, smitha

Report Name D:\PrachiJoglekar\PRACHI\OnlinePaymentSystem\USERWISE.rptLoaded Report Loaded Report could not create report pdf CrystalDecisions.CrystalReports.Engine.ParameterFieldCurrentValueException: Missing parameter values. ---> System.Runtime.InteropServices.COMException (0x8004100E): Missing parameter values. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() at USERWISE.CreateReport(String sReport, String sReportFormula)

works fine for me. thanks also i need a pdf report in new page and not in the same page. if asattachments is given as true, i get a box which asks for Open/Save/Cancel. and opens in a new page i dosent need any questions. if i give print, i just need to get printed as PDF in a new page. Anyone pls help me Thanks in advance.

Hi Mahesh I tried creating the report as you said.But i get an System.Threading.ThreadAbortException with the message "Unable to evaluate expression because the code is optimized or there is a native frame on top of the call stack" at the report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, False, "ExportedReport") line due to which i get a blank browser window without the report.Please guide me. Regards Santhosh

did everything that was in your article, but I am getting a Database Logon error. The error was: CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocument.y(ExportOptions R) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportOptions options, HttpResponse response, Boolean asAttachment, String attachmentName) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportFormatType formatType, HttpResponse response, Boolean asAttachment, String attachmentName) at CIMS.crpt_equipmentTypeNumIssues.btn_export_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\cims2\Star\report\crpt\crpt_equipmentTypeNumIssues.aspx.vb:line 380 I am using Crystal Report XI and PUSH method. I don’t understand why it will ask for Database credentails as I am using the PUSH model. I hope you can help me. Thank you in advance.

HELLO, I M KALPANA I M FACING PROBLEM WHILE EXPORTING CRYSTAL REPORT TO PDF WITH PARAMETERS. IT IS GIVING ME CORRECT OUTPUT IN CRYSTALREPORTVIEWER BUT I M NOT GETTING ANY DATA INTO PDF FILE.IT IS JUST SHOWING TITLE AND BOX IN PDF BUT NOT DATA.IF I PASS ONE PARAMETER IT IS SHOWING REPORT IN PDF WITH CORRECT DATA BUT NOT FOR MORE THAN ONE PARAMETERS. WILL U PLZ HELP ME IN THIS MATTER. CODE I M USING IS ReportDocument crReportDocument= new ReportDocument(); crReportDocument.Load(Server.MapPath("cryForAllLockerTypes.rpt")); crReportDocument=con.GetConnection(crReportDocument); ParameterDiscreteValue crtParamDiscreteValue; ParameterField crtParamField; ParameterFields crtParamFields; crtParamDiscreteValue = new ParameterDiscreteValue(); crtParamField = new ParameterField(); crtParamFields = new ParameterFields(); crtParamDiscreteValue.Value = "028"; crtParamField.ParameterFieldName = "sol"; crtParamField.CurrentValues.Add(crtParamDiscreteValue); crtParamFields.Add(crtParamField); crtParamDiscreteValue = new ParameterDiscreteValue(); crtParamField= new ParameterField(); crtParamDiscreteValue.Value = "00"; crtParamField.ParameterFieldName = "extn"; crtParamField.CurrentValues.Add(crtParamDiscreteValue); crtParamFields.Add(crtParamField); crtParamDiscreteValue = new ParameterDiscreteValue(); crtParamField= new ParameterField(); crtParamDiscreteValue.Value = txtCabFrom.Text; crtParamField.ParameterFieldName = "cabfrom"; crtParamField.CurrentValues.Add(crtParamDiscreteValue); crtParamFields.Add(crtParamField); crtParamDiscreteValue = new ParameterDiscreteValue(); crtParamField= new ParameterField(); crtParamDiscreteValue.Value = txtCabTo.Text; crtParamField.ParameterFieldName = "cabto"; crtParamField.CurrentValues.Add(crtParamDiscreteValue); crtParamFields.Add(crtParamField); crReportDocument.SetParameterValue("extn",crtParamDiscreteValue); crReportDocument.SetParameterValue("sol",crtParamDiscreteValue); crReportDocument.SetParameterValue("cabfrom",crtParamDiscreteValue); crReportDocument.SetParameterValue("cabto",crtParamDiscreteValue); CrystalReportViewer1.ParameterFieldInfo = crtParamFields; CrystalReportViewer1.ReportSource=crReportDocument; CrystalReportViewer1.DataBind(); crReportDocument.ExportOptions.ExportFormatType =ExportFormatType.PortableDocFormat; crReportDocument.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); diskOpts.DiskFileName ="C:\\Report44.pdf"; //"c:\\try.pdf"; crReportDocument.ExportOptions.DestinationOptions = diskOpts; crReportDocument.Export(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; string filename1 = "attachment;filename="+"Report44.pdf"; Response.AddHeader("Content-Disposition", filename1); Response.WriteFile("C:\\Report44.pdf"); Response.Flush(); Response.Close(); System.IO.File.Delete("C:\\Report44.pdf"); CLIENT SIDE CODE.FILE MUST BE CREATED ON CLIENT MACHINE.