Crystal Report Error Vendor Code : 241

I develop a Window application in C# window application with Visual Studio 2012
for that i used Crystal Reporting Service

in Crystal report I append Stored Procedure as Data-Source which wants 4 parameters

I passed that parameter from C# window form with this below code

ReportDocument cryRpt = new ReportDocument();

cryRpt.Load(@"E:\TestDatabase\TestDatabase\RejectionReport.rpt"); ConnectionInfo crConnectionInfo = new ConnectionInfo(); crConnectionInfo.ServerName = @".\SqlExpress"; crConnectionInfo.DatabaseName = "testdatabase"; crConnectionInfo.IntegratedSecurity = true; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = dateTimePickerFromRejectionReport.Text; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@FromDate"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = dateTimePickerToRejectionReport.Text; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@ToDate"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = CBItemTypeRejectionRpt.Text;

crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Type"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

crParameterDiscreteValue.Value = "HT";
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@RegStage"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();

this all parameters are passed successfully in my report but at the loading time of report in report viewer I got the Error

"Failed to retrieve data from the database Database Vendor Code : 241
Error in File Rejection Reprort {a6sd78t3287-2167-sdfg3-8asdgbgbsadh}.rpt
Failed to retrieve data from the database.
Detais [Database Vendor Code : 241]"

please help me to solve this out

try

{

string fname = "Reports.pdf";

SqlDataAdapter da = new SqlDataAdapter();

voucherdetails = new VoucherDetailsLogic();

dt = new DataTable();

dt = voucherdetails.SelectVoucherEntriesDetailsbyDatewise(Convert.ToDateTime(txtfromdate.Text), Convert.ToDateTime(txttodate.Text));

ReportDocument crystalReport = new ReportDocument(); // creating object of crystal report

crystalReport.Load(Server.MapPath(@"~/Reports/Accounts/Rpt_Balancesheet.rpt")); // path of report

crystalReport.SetDataSource(dt); // binding datatable

CrystalReportViewer1.ReportSource = crystalReport;

crystalReport.SetParameterValue("from", Convert.ToDateTime(txtfromdate.Text));

crystalReport.SetParameterValue("to", Convert.ToDateTime(txttodate.Text));

ExportOptions exprtopt = default(ExportOptions);

DiskFileDestinationOptions destiopt = new DiskFileDestinationOptions();

ReportDocument RptDoc = new ReportDocument();

destiopt.DiskFileName = Server.MapPath(fname);

exprtopt = crystalReport.ExportOptions;

exprtopt.ExportDestinationType = ExportDestinationType.DiskFile;

exprtopt.ExportFormatType = ExportFormatType.PortableDocFormat;

exprtopt.DestinationOptions = destiopt;

crystalReport.Export();

string Path = Server.MapPath(fname);

WebClient client = new WebClient();

Byte[] buffer = client.DownloadData(Path);

Response.Write("");

}

catch (Exception ex)

{

lblmess.ForeColor = System.Drawing.Color.Red;

lblmess.Text = ex.Message.ToString();

this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message + "');", true);

}

1 Reply

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

Imtiyaz Ansari12y ago
try
{

string fname = "Reports.pdf";

SqlDataAdapter da = new SqlDataAdapter();
voucherdetails = new VoucherDetailsLogic();
dt = new DataTable();
dt = voucherdetails.SelectVoucherEntriesDetailsbyDatewise(Convert.ToDateTime(txtfromdate.Text), Convert.ToDateTime(txttodate.Text));

ReportDocument crystalReport = new ReportDocument(); // creating object of crystal report
crystalReport.Load(Server.MapPath(@"~/Reports/Accounts/Rpt_Balancesheet.rpt")); // path of report

crystalReport.SetDataSource(dt); // binding datatable
CrystalReportViewer1.ReportSource = crystalReport;
crystalReport.SetParameterValue("from", Convert.ToDateTime(txtfromdate.Text));
crystalReport.SetParameterValue("to", Convert.ToDateTime(txttodate.Text));

ExportOptions exprtopt = default(ExportOptions);
DiskFileDestinationOptions destiopt = new DiskFileDestinationOptions();

ReportDocument RptDoc = new ReportDocument();

destiopt.DiskFileName = Server.MapPath(fname);

exprtopt = crystalReport.ExportOptions;
exprtopt.ExportDestinationType = ExportDestinationType.DiskFile;

exprtopt.ExportFormatType = ExportFormatType.PortableDocFormat;
exprtopt.DestinationOptions = destiopt;

crystalReport.Export();

string Path = Server.MapPath(fname);

WebClient client = new WebClient();

Byte[] buffer = client.DownloadData(Path);

Response.Write("");

}
catch (Exception ex)
{
lblmess.ForeColor = System.Drawing.Color.Red;
lblmess.Text = ex.Message.ToString();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message + "');", true);

}
0