using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
ReportDocument rpt;
------in page load-------
ConfigureCrystalReports("Datewise.rpt");
CrystalReportViewer1.DataBind();
--------copy and paste these two below functions----------
private void ConfigureCrystalReports(string path)
{
rpt = new ReportDocument();
string reportPath = Server.MapPath(path);
rpt.Load(reportPath);
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "fms_new";
connectionInfo.UserID = "sa";
connectionInfo.Password = "sa";
SetDBLogonForReport(connectionInfo, rpt);
CrystalReportViewer1.ReportSource = rpt;
}
private void SetDBLogonForReport(ConnectionInfo connectionInfo, ReportDocument reportDocument)
{
Tables tables = reportDocument.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
table.ApplyLogOnInfo(tableLogonInfo);
}
}
No comments:
Post a Comment