Getting the error for Report

Question

Hi, I am getting the report after click on print button. i have installed te crystal report version the error below Error Failed to open the connection. ProformaInvoice 9908_20416_{DFFD5BF1-A205-4E33-9292-93B15005D4FC}.rpt Details: [Database Vendor Code: 17 ]

Debasis Mohapatra · Answer

Hi Kalyani, I have solved it acctualy the connection has not done properly with the sql server that's why the error was happening. now the report is displaying properly.

Kalyani Shevale · Answer

refer below Link https://apps.support.sap.com/sap/support/knowledge/public/en/1676673 https://archive.sap.com/discussions/thread/3945873 https://medium.com/@satawneh/crystal-reports-failed-to-open-connection-code-17-2f4176f169af https://www.codeproject.com/questions/667950/crystal-reports-connection-to-sql-server-database

Debasis Mohapatra · Answer

Thank you Shevale for your reply, but i have done in the same way can you please check my below code. In webconfigi have checked all is correct. why the error is happening. private void printdocument(string inno) { ReportDocument rpp = null; try { rpp = new ReportDocument(); string pathh = Server.MapPath("..\Upload"); string totalPAth = Server.MapPath("ProductionOrder.rpt"); rpp.Load(totalPAth); rpp.SetParameterValue("docno", inno); rpp.SetParameterValue("pathh", pathh); CrystalReportViewer1.ReportSource = rpp; CrystalReportViewer1.DataBind(); SetCRLogOnInfo(rpp, @"SDF-WS", "sa", "abcd-1234", "DBBJBPL1"); } catch (Exception ex) { } finally { } } public void SetCRLogOnInfo(ReportDocument mainInRD, string dataSource, string userId, string pwd, string database) { //do the main reports database TableLogOnInfo logonInfo = null; foreach (CrystalDecisions.CrystalReports.Engine.Table table in mainInRD.Database.Tables) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo.ServerName = dataSource; logonInfo.ConnectionInfo.DatabaseName = database; logonInfo.ConnectionInfo.UserID = userId; logonInfo.ConnectionInfo.Password = pwd; table.ApplyLogOnInfo(logonInfo); } try { //now update logon info for all sub-reports if (!mainInRD.IsSubreport && mainInRD.Subreports != null && mainInRD.Subreports.Count > 0) { foreach (ReportDocument rd in mainInRD.Subreports) { SetCRLogOnInfo(rd, dataSource, userId, pwd, database); } } } catch { } }

Getting the error for Report

Answers (3)