Crystal Report throwing Missing Parameter while PDF export

Durga Velusamy

9y1.5kVisual Basic .NET

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

6 Replies

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

Amit Gupta9y ago
Accepted 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
+1
Durga Velusamy9y ago
Thank you so much . its worked well. Thanks once again.
0
Durga Velusamy9y ago
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\todataydate.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);
}
}

0
Amit Gupta9y ago
Please clarify!! What does it mean.
0
Durga Velusamy9y ago
but i can able to see the report.
iam try to export pdf due to report generation only.
0
Amit Gupta9y ago
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
+1