Crystal Reports Runtime Fixed 〈TRUSTED CHOICE〉

// Set database logon info ConnectionInfo connInfo = new ConnectionInfo(); connInfo.ServerName = "YOUR_SQL_SERVER"; connInfo.DatabaseName = "YourDatabase"; connInfo.UserID = "yourUser"; connInfo.Password = "yourPassword";

// Set parameters if needed report.SetParameterValue("@StartDate", DateTime.Now.AddDays(-30)); report.SetParameterValue("@EndDate", DateTime.Now); crystal reports runtime

using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; // Load the report ReportDocument report = new ReportDocument(); report.Load(@"C:\Reports\MyReport.rpt"); // Set database logon info ConnectionInfo connInfo =

// Assign to CrystalReportViewer crystalReportViewer1.ReportSource = report; connInfo.ServerName = "YOUR_SQL_SERVER"

Here’s a showing how to load and set a database connection for a Crystal Reports report at runtime in a .NET application (C#):

Requires CrystalDecisions.CrystalReports.Engine and CrystalDecisions.Shared DLLs (SAP Crystal Reports runtime for .NET).