Crystal Reports Runtime 【Direct TRICKS】

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

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

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

// Assign to CrystalReportViewer crystalReportViewer1.ReportSource = report; logOnInfo.ConnectionInfo = connInfo

// Apply to all tables foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables) { TableLogOnInfo logOnInfo = table.LogOnInfo; logOnInfo.ConnectionInfo = connInfo; table.ApplyLogOnInfo(logOnInfo); }

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