public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Rep_DepositPositionProductWiserpt rpt = new Rep_DepositPositionProductWiserpt(); rpt.Site = this.Site; return(rpt); }
protected void Page_Load(object sender, EventArgs e) { Rep_DepositPositionProductWiserpt rd = new Rep_DepositPositionProductWiserpt(); ConnectionInfo conne = new ConnectionInfo(); conne.ServerName = ConfigurationManager.AppSettings["ServerName"].ToString(); conne.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"].ToString(); conne.UserID = ConfigurationManager.AppSettings["UserID"].ToString(); conne.Password = ConfigurationManager.AppSettings["Password"].ToString(); TableLogOnInfo tablelogs = new TableLogOnInfo(); Database db = rd.Database; Tables tbls = db.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table tab in tbls) { tablelogs = tab.LogOnInfo; tablelogs.ConnectionInfo = conne; tab.ApplyLogOnInfo(tablelogs); tab.Location = ConfigurationManager.AppSettings["DatabaseName"] + ".dbo." + tab.Name; //most important line whole report is depend on this line } CrystalReportViewer1.ReportSource = rd; CrystalReportViewer1.Zoom(Convert.ToInt16(ConfigurationManager.AppSettings["ReportZoom"])); CrystalReportViewer1.SelectionFormula = "{REP_BRANCH_BALANCES.ACCT_TYPE} in [115, 116, 137, 136, 138] and {REP_BRANCH_BALANCES.TRANDATE} = cdate('" + txtAsOnDate.Text + "')"; CrystalReportViewer1.RefreshReport(); }