I work on crystal report Version 13 . I have main report have multi sub report my issue I get error after add second sub report
error in File temp_.rpt:\nUnable to connect: incorrect log on parameters.
this error happen after add second sub report and if I add any field on details section of second sub report error happened
if I leave details section empty of second sub report it working without any issue
I fill second sub report with
cr.Database.Tables["exchange_bulk_trans_settlements"].SetDataSource(exchange_bulk_trans_settlements)
full code csharp that fill report
public bool GetVendorsBulkTransactionsReport(string p_tenant_id, string p_permid, string p_userid, string p_language, string p_org_id, string p_from_date, string p_to_date, string p_vendor_id,string VendroName) { MyDatabase db = new MyDatabase(); ResponseStatus response = new ResponseStatus(); try { RptGetVendorsBulkTransactions cr = new RptGetVendorsBulkTransactions(); var ds = db.GetVendorsBulkTransactionsReport(p_tenant_id, p_permid, p_userid, p_language, p_org_id, p_from_date, p_to_date, p_vendor_id); var exchange_bulk_trans_lines = ds.Tables["exchange_bulk_trans_lines"]; var exchange_bulk_trans_settlements = ds.Tables["exchange_bulk_trans_settlements"]; if (ds != null) { if (ds.Tables.Count > 0 && exchange_bulk_trans_lines.Rows.Count > 0 && exchange_bulk_trans_settlements.Rows.Count > 0) { cr.Database.Tables["exchange_bulk_trans_settlements"].SetDataSource(exchange_bulk_trans_settlements); cr.Database.Tables["exchange_bulk_trans_lines"].SetDataSource(exchange_bulk_trans_lines); CrystalReportViewer1.ReportSource = cr; ExportFormatType formatType = ExportFormatType.PortableDocFormat; cr.exortresponse(formatType, Response, false, string.Format("??? ?????? ?????")); return true; return true; } else { cr.Close(); cr.Dispose(); GC.Collect(); response = db.ErrorLog(MethodBase.GetCurrentMethod().Name, Common.GetStringWithoutQuate("No data available"), "Error while displaying the Vendor Bulk Transactions Report", "app_sabayik.get_risk_eval_lookups", null, null, "req.P_PERM_ID = ", "P_COMPANY_NAME = ", "P_USER = "); Response.Write("Unable to print the report at this time. Please try again later."); return false; } } else { cr.Close(); cr.Dispose(); GC.Collect(); response = db.ErrorLog(MethodBase.GetCurrentMethod().Name, Common.GetStringWithoutQuate("No data available"), "Error while displaying the Vendor Bulk Transactions Report", "app_sabayik.get_risk_eval_lookups", null, null, "req.P_PERM_ID = ", "P_COMPANY_NAME = ", "P_USER = "); Response.Write("Unable to print the report at this time. Please try again later."); return false; } } catch (Exception ex) { GC.Collect(); if (ex.Message != "Thread was being aborted.") { response = db.ErrorLog(MethodBase.GetCurrentMethod().Name, Common.GetStringWithoutQuate(ex.Message), "Error while displaying the Vendor Bulk Transactions Report", "app_sabayik.get_risk_eval_lookups", null, null, "req.P_PERM_ID = ", "P_COMPANY_NAME = ", "P_USER = "); Response.Write(response.StatusDesc.ToString()); } return false; } }