locked
calling a Crystal Report from C# app that is connected to SQL Server database RRS feed

  • Question

  • Using Visual Studio 2017, Crystal Reports 2016, and SQL Server Express 2017.  I designed the Crystal Report directly in Crystal Reports and connected to my development connection to SQL Server.  Works fine from the C# app in development, but when I move everything to production (also uses SQL Server Express but is obviously a different machine name), I get an error when crystal reports is called.  Even though the C# app is using the correct XML configuration file for production machine, do I still need to code something to tell Crystal Reports to logon to the correct SQL server?  Here is my code in calling the report:

                

    frmDepartment FormDepartment = new frmDepartment();

                hDeptName = FormDepartment.txtDeptName.Text.ToString();

                hDeptName = FormDepartment.txtDeptName.ToString();
                hDeptName = "CIT";

                ReportDocument cryRpt = new ReportDocument();

    cryRpt.Load(Application.StartupPath + "\\DepartmentList.rpt");
                crystalReportViewer1.ReportSource = cryRpt;
                cryRpt.SetParameterValue("@DeptName", hDeptName);
             //   cryRpt.SetParameterValue("@Name", TextBox2.Text.ToString());
                crystalReportViewer1.Refresh();

    Sunday, December 9, 2018 10:04 PM

All replies