Crystal Report Error exporting records in Excel format.

Hi Purba,

what this error come bind crystal reports or when export in excel format. am not sure but sound look like this type of error come when pass parameters

ReportDocumentcryRpt=newReportDocument();
cryRpt.Load(Environment.CurrentDirectory+"\\Reports\\CashReceipt_DL_JHARKHAND.rpt");
TableLogOnInfocrtableLogoninfo=newTableLogOnInfo();
ConnectionInfocrConnectionInfo=newConnectionInfo();
TablesCrTables;
crConnectionInfo.ServerName=ConnectionDetails.DSNName;
crConnectionInfo.DatabaseName=ConnectionDetails.DatabaseName;
crConnectionInfo.UserID=ConnectionDetails.UserID;
crConnectionInfo.Password=ConnectionDetails.Password;
CrTables=cryRpt.Database.Tables;
foreach(CrystalDecisions.CrystalReports.Engine.TableCrTableinCrTables)
{
crtableLogoninfo=CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo=crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
cryRpt.Refresh();
cryRpt.RecordSelectionFormula="{DL_INFO.DLNUMBER}=\""+txtDLNo.Text+"\"";
cryRpt.PrintToPrinter(1,true,1,1);

Please check above code and let me know if face any problem.

2 Replies

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

Vishal Jadav10y ago
Accepted answer
Hi,

It's been a long i worked crystal report.

But according to the message it says that a parameter is missing its value.

Might be your formula field or any db field value is not available.

Try debugging the code and try to identify the each field values.

You will get the error origin.

Thanks.
0
Joginder Banger10y ago
Hi Purba,
what this error come bind crystal reports or when export in excel format. am not sure but sound look like this type of error come when pass parameters
ReportDocumentcryRpt=newReportDocument();
cryRpt.Load(Environment.CurrentDirectory+"\\Reports\\CashReceipt_DL_JHARKHAND.rpt");
TableLogOnInfocrtableLogoninfo=newTableLogOnInfo();
ConnectionInfocrConnectionInfo=newConnectionInfo();
TablesCrTables;
crConnectionInfo.ServerName=ConnectionDetails.DSNName;
crConnectionInfo.DatabaseName=ConnectionDetails.DatabaseName;
crConnectionInfo.UserID=ConnectionDetails.UserID;
crConnectionInfo.Password=ConnectionDetails.Password;
CrTables=cryRpt.Database.Tables;
foreach(CrystalDecisions.CrystalReports.Engine.TableCrTableinCrTables)
{
crtableLogoninfo=CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo=crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
cryRpt.Refresh();
cryRpt.RecordSelectionFormula="{DL_INFO.DLNUMBER}=\""+txtDLNo.Text+"\"";
cryRpt.PrintToPrinter(1,true,1,1);
Please check above code and let me know if face any problem.
0