public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RptConsolidatedPO rpt = new RptConsolidatedPO(); rpt.Site = this.Site; return(rpt); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { Int32 i32Vessel_Code = Convert.ToInt32(Session["i32Vessel_Code"]); string strAgent_Code = Convert.ToString(Session["strAgent_Code"]); using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { DataSet dtsPoItemsList = objTechService.GetPOItemListForReport(i32Vessel_Code, strAgent_Code); ConnectionInfo cInfo = new ConnectionInfo(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["smsconn"].ToString(); string[] conn = connstring.ToString().Split(';'); string[] serverInfo = conn[0].ToString().Split('='); string[] DbInfo = conn[1].ToString().Split('='); string[] userInfo = conn[2].ToString().Split('='); string[] passwordInfo = conn[3].ToString().Split('='); cInfo.ServerName = serverInfo[1].ToString(); cInfo.DatabaseName = DbInfo[1].ToString(); cInfo.UserID = userInfo[1].ToString(); cInfo.Password = passwordInfo[1].ToString(); CrystalReports.RptConsolidatedPO objRptConsolidatedPO = new CrystalReports.RptConsolidatedPO(); foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objRptConsolidatedPO.Database.Tables) { logOnInfo = reportTable.LogOnInfo; logOnInfo.ConnectionInfo = cInfo; reportTable.ApplyLogOnInfo(logOnInfo); } crvConsolidatedPO.ReportSource = objRptConsolidatedPO; objRptConsolidatedPO.SetDataSource(dtsPoItemsList.Tables[0]); crvConsolidatedPO.DisplayToolbar = true; } //} } catch (Exception ex) { //.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex); } finally { Session.Remove("ArrListOfPO_ID"); Session.Remove("StringArrayInfoPO"); } } }