protected void btn1_Click(object sender, EventArgs e) { ReportDocument cr = new ReportDocument(); cr.Load(Server.MapPath("~/Installation Report.rpt")); TableLogOnInfo logOnInfo = new TableLogOnInfo(); // I am assuming that you have crystal server database // connection strings in your web.config logOnInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["strServer"].ToString(); logOnInfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["strDBase"].ToString(); logOnInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["strUID"].ToString(); logOnInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["strPWD"].ToString(); TableLogOnInfo login = default(TableLogOnInfo); foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in cr.Database.Tables) { login = tbl.LogOnInfo; login.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["strServer"].ToString(); login.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["strDBase"].ToString(); login.ConnectionInfo.UserID = ConfigurationManager.AppSettings["strUID"].ToString(); login.ConnectionInfo.Password = ConfigurationManager.AppSettings["strPWD"].ToString(); tbl.ApplyLogOnInfo(login); Cr1.DataBind(); cr.SetParameterValue("ASSETID", asstid.Text); Cr1.ReportSource = cr; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)