Wednesday, April 8, 2009

To disable the crystal report login credentials

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: