public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { QuotationEval rpt = new QuotationEval(); rpt.Site = this.Site; return(rpt); }
private void bindReports() { string strRptPath = Server.MapPath("."); DataTable dtbl = new DataTable(); // DataSet ds = new DataSet(); DataTable ReqInfo = new DataTable(); ReqInfo = (DataTable)Session["Tabl1"]; DataTable IntemInfo = new DataTable(); IntemInfo = (DataTable)Session["Tabl2"]; DataTable SupInfo = new DataTable(); SupInfo = (DataTable)Session["Tabl3"]; ConnectionInfo cInfo = new ConnectionInfo(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); //string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["elogcon"].ToString(); //cInfo.ServerName = "elogsrv"; //cInfo.DatabaseName = "eLog"; //cInfo.UserID = "sa"; //cInfo.Password = "******"; 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(); DataTable dtitem = new DataTable(); dtitem = ceateTable(IntemInfo, SupInfo); CrystalReportsFile.QuotationEval objQtyReport = new CrystalReportsFile.QuotationEval(); foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objQtyReport.Database.Tables) { logOnInfo = reportTable.LogOnInfo; logOnInfo.ConnectionInfo = cInfo; reportTable.ApplyLogOnInfo(logOnInfo); } objQtyReport.Load(strRptPath + "\\QuotationEval.rpt"); //objQtyReport.DataDefinition.FormulaFields[1].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString(); //objQtyReport.DataDefinition.FormulaFields[2].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString(); //objQtyReport.DataDefinition.FormulaFields[3].Text = ReqInfo.Rows[0]["SYSTEM_Description"].ToString(); //objQtyReport.DataDefinition.FormulaFields[4].Text = ReqInfo.Rows[0]["TOTAL_ITEMS"].ToString(); //objQtyReport.DataDefinition.FormulaFields[5].Text = ReqInfo.Rows[0]["requestion_Date"].ToString(); //objQtyReport.DataDefinition.FormulaFields[6].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString(); objQtyReport.OpenSubreport("SubReportsForSupp").SetDataSource(SupInfo); objQtyReport.OpenSubreport("RequsitionDetail").SetDataSource(ReqInfo); objQtyReport.SetDataSource(dtitem); CrystalReportViewer.ReportSource = objQtyReport; CrystalReportViewer.ParameterFieldInfo = paramFields; CrystalReportViewer.DisplayToolbar = true; }