Crystal Report Error exporting records in Excel format.

Question

Help me....

Vishal Jadav · 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.

Joginder Banger · Answer

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= new ReportDocument(); cryRpt.Load(Environment.CurrentDirectory+ "\Reports\CashReceipt_DL_JHARKHAND.rpt" ); TableLogOnInfocrtableLogoninfo= new TableLogOnInfo(); ConnectionInfocrConnectionInfo= new ConnectionInfo(); 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.TableCrTable in CrTables) { 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.