Crystal Report throwing Missing Parameter while PDF export

Question

Crystal Report throwing Missing Parameter while PDF export only some times . DateTime prntdate=DateTime.Now; string printeddate=prntdate.ToString(dd/MM/yyyy); if (!Directory.Exists(@D:/Bills/ + printeddate)) { Directory.CreateDirectory(@D:/Bills/ + printeddate); } CrDiskFileDestinationOptions.DiskFileName = D:\Bills\ + printeddate + \ + label1.Text + .pdf; CrExportOptions = crystalReport.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } crystalReport.Export();

Amit Gupta · Answer

You need to make some changes 1. Remove the line because it has been declared twice myParams; //Add Paramater crystalReportViewer1.ReportSource = crystalReport; ParameterField name2 = null; //you should also change the way of passing the parameters check below reference http://stackoverflow.com/questions/1589021/passing-parameters-to-crystal-reports-in-c-sharp 2. In the export method string accdate = printdate.ToString(dd/MM/yyyy). Replace (/ _) ; // illegal character string folder = @D: / Accounts; //should be replaced with \ string fullPath = D:\Accounts\ + accdate + .pdf; if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } if ( Directory.Exists (fullPath)) // replace with File.Exists { File.Delete(fullPath); } Else other snippets seems fine

Amit Gupta · Answer

I believe that you had passed all the required parameter to crystal report. Just to keep in mind that if you are Refreshing the report all the parameters need to be passed again because it all gets wiped. Do check and let me know if it works

Durga Velusamy · Answer

Thank you so much . its worked well. Thanks once again.

Durga Velusamy · Answer

acctualy report generated. DataSet1 dsCustomers = GetData(); crystalReport.SetDataSource(dsCustomers); ParameterFields myParams = null; ParameterField name = null; ParameterDiscreteValue valYear = null; myParams = new ParameterFields(); name = new ParameterField(); valYear = new ParameterDiscreteValue(); name.ParameterFieldName = @Fromdate; valYear.Value = fdate.ToString(dd/MM/yyyy); name.CurrentValues.Add(valYear); myParams.Add(name); crystalReportViewer1.ParameterFieldInfo = myParams; //Add Paramater crystalReportViewer1.ReportSource = crystalReport; ParameterField name2 = null; ParameterDiscreteValue valYear2 = null; name2 = new ParameterField(); valYear2 = new ParameterDiscreteValue(); name2.ParameterFieldName = @Todate; valYear2.Value = tdate.ToString(dd/MM/yyyy); name2.CurrentValues.Add(valYear2); myParams.Add(name2); crystalReportViewer1.ParameterFieldInfo = myParams; crystalReportViewer1.ReportSource = crystalReport; /// here report generated i can view report . ExportFile(); this function only not exporting in some times only. i need to export Account	odataydate.pdf i created folder Account. public void ExportFile() { try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); DateTime printdate = DateTime.Now; string accdate = printdate.ToString(dd/MM/yyyy); string folder = @D:/Accounts; string fullPath = D:\Accounts\ + accdate + .pdf; if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } if (Directory.Exists(fullPath)) { File.Delete(fullPath); } // crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat fullPath); CrDiskFileDestinationOptions.DiskFileName = folder+/+ accdate + .pdf; CrExportOptions = crystalReport.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } crystalReport.Export(); } catch (Exception ex) { //MessageBox.Show(Error: + ex); } }

Amit Gupta · Answer

Please clarify!! What does it mean.

Durga Velusamy · Answer

but i can able to see the report. iam try to export pdf due to report generation only.