private void MakeReport(bool save = false) { string oonum = "-"; string oodate = "-"; string propno = this.propno.ToString(); if (save) { oonum = txtoonum.Text; oodate = txtoodate.Text; } string sql = "select * from cadre.prop_redesig where propno = " + propno + " order by fdate,empid"; OraDBConnection oraCn = new OraDBConnection(); System.Data.DataSet ds = OraDBConnection.GetData(sql); string pdfPath; if (save) { pdfPath = Server.MapPath("office_orders\\" + oonum + "-BEG-I" + oodate + ".pdf"); } else { pdfPath = Server.MapPath("office_orders\\preview_rdg-" + propno + "-" + DateTime.Now.ToString("yyyyMMdd-HHmmssfff") + ".pdf"); } CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptredesig.rpt"); CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]); CrystalReportSource1.DataBind(); CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath); Utils.DownloadFile(pdfPath); }
protected void BindInfo() { CustAdviceModel model = new CustAdviceModel(); UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; /*接受参数*/ model.ID = Convert.ToInt32(Request.QueryString["ID"].ToString()); string CompanyCD = UserInfo.CompanyCD; /*读取数据*/ DataTable dtDetail = new DataTable(); DataTable dt = XBase.Business.Office.CustManager.CustAdviceBus.GetOneCustAdviceInfo(model); /*绑定RPT*/ if (dt != null) { /*加载主报表*/ this.CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/CustManager/CustAdvice.rpt")); CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.CustAdvice")); //绑定数据 CrystalReportSource1.ReportDocument.SetDataSource(dt); CrystalReportSource1.DataBind(); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName); CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName); CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName); this.CrystalReportViewer1.ReportSource = CrystalReportSource1; } }
protected void Page_Load(object sender, EventArgs e) { SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead); rs.Open("SELECT no from [EIPB].[dbo].cxmt310_in_head where id='" + Request.QueryString["id"] + "' "); if (!rs.EOF) { string sql; sql = "EXEC CXMT310_Report1 '" + rs["no"].ToString() + "'"; string DBConfig_sql = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["EIPBConnectionString"].ConnectionString; DataSet ds = new DataSet(); SqlConnection sqlCon = new SqlConnection(DBConfig_sql); SqlDataAdapter sqlAd = new SqlDataAdapter(); SqlCommand sqlCmd = new SqlCommand(sql, sqlCon); sqlAd.SelectCommand = sqlCmd; sqlAd.Fill(ds, "sql"); CrystalReportSource1.ReportDocument.Load(Server.MapPath("CXMT310_Report1.rpt")); CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["sql"]); CrystalReportSource1.DataBind(); CrystalReportViewer1.ReportSource = CrystalReportSource1; } CrystalReportViewer1.DisplayGroupTree = false; }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlDeptName.SelectedValue != "0")//部门 { searchModel.QuarterID = ddlDeptName.SelectedValue; } if (this.ddlStartMonth.SelectedValue != "0") //起始月份 { searchModel.AdminLevel = ddlStartMonth.SelectedValue; } if (this.ddlEndMonth.SelectedValue != "0") //结束月份 { searchModel.AdminLevelName = ddlEndMonth.SelectedValue; } if (this.ddlYear.SelectedValue != "0") //结束月份 { searchModel.UnitPrice = ddlYear.SelectedValue; } UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtNewTable = SalaryStandardBus.SearchSalarySummaryReport(searchModel); DataTable dtData = new DataTable(); dtData.Columns.Add("Remark"); dtData.Columns.Add("itemNo"); dtData.Columns.Add("CompanyCD"); dtData.Columns.Add("UnitPrice"); for (int i = 0; i < dtNewTable.Rows.Count; i++) { DataRow newRow = dtData.NewRow(); newRow["Remark"] = getDeptName(dtNewTable.Rows[i]["Remark"] == null ? "" : dtNewTable.Rows[i]["Remark"].ToString()); newRow["itemNo"] = dtNewTable.Rows[i]["itemNo"] == null ? "" : dtNewTable.Rows[i]["itemNo"].ToString(); newRow["CompanyCD"] = dtNewTable.Rows[i]["CompanyCD"] == null ? "" : dtNewTable.Rows[i]["CompanyCD"].ToString(); newRow["UnitPrice"] = dtNewTable.Rows[i]["UnitPrice"] == null ? "" : dtNewTable.Rows[i]["UnitPrice"].ToString(); dtData.Rows.Add(newRow); } ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalarySummeryReport.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; //CrystalReportViewer1.DataBind(); }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlSearchQuarter.SelectedValue != "0") { searchModel.QuarterID = ddlSearchQuarter.SelectedValue; } //岗位职等 if (ddlSearchQuaterAdmin.SelectedValue != "0") { searchModel.AdminLevel = ddlSearchQuaterAdmin.SelectedValue; } //启用状态· searchModel.UsedStatus = "1"; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtData = SalaryStandardBus.SearchSalaryStandardReport(searchModel); ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryStandardReport.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryStandard")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; if (ddlSearchQuarter.SelectedValue != "0" && ddlSearchQuarter.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + ddlSearchQuarter.Items[ddlSearchQuarter.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + "全部" + "\""; } if (this.ddlSearchQuaterAdmin.SelectedValue != "0" && ddlSearchQuaterAdmin.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + ddlSearchQuaterAdmin.Items[ddlSearchQuaterAdmin.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + "全部" + "\""; } CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
//public void DataBindToDept() //{ // DataTable dt = PerformanceQueryBus.SearchDeptInfo(); // ddlDeptName.DataSource = dt; // ddlDeptName.DataTextField = "DeptName"; // ddlDeptName.DataValueField = "ID"; // ddlDeptName.DataBind(); // ddlDeptName.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0")); // ddlDeptName.SelectedValue = "0"; //} public void Search() { ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/EmployeeExamination.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary")); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; EmployeeTestSearchModel searchModel = new EmployeeTestSearchModel(); searchModel.Addr = Request.Form["hidDeptID"] == null ? "" : Request.Form["hidDeptID"].ToString(); searchModel.StatusName = Request.Form["txtSearchEmployeeID"] == null ? "" : Request.Form["txtSearchEmployeeID"].ToString(); searchModel.StartDate = txtStartDate.Value; searchModel.StartToDate = txtStartToDate.Value; searchModel.EndDate = txtEndDate.Value; searchModel.EndToDate = txtEndToDate.Value; searchModel.CompanyCD = userInfo.CompanyCD; //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "开始日期:" + txtStartDate.Value + " 至 " + txtStartToDate.Value + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束日期:" + txtEndDate.Value + " 至 " + txtEndToDate.Value + "\""; DataTable dtData = EmployeeTestBus.EmployeeExaminationReportInfo(searchModel); DataTable dt = new DataTable(); DataColumn newCol = new DataColumn("LevelType"); DataColumn newCol2 = new DataColumn("ID"); dt.Columns.Add(newCol); dt.Columns.Add(newCol2); if (dtData.Rows.Count > 0) { for (int i = 0; i < dtData.Rows.Count; i++) { DataRow sk = dt.NewRow(); string deptName = EmployeeTestBus.getDept(dtData.Rows[i]["LevelType"] == null ? "" : dtData.Rows[i]["LevelType"].ToString()); sk["LevelType"] = deptName; sk["ID"] = dtData.Rows[i]["ID"] == null ? "" : dtData.Rows[i]["ID"].ToString(); dt.Rows.Add(sk); } } CrystalReportSource1.ReportDocument.SetDataSource(dt); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
protected void BindInfo() { UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; /*接受参数*/ int ID = Convert.ToInt32(Request.QueryString["ID"].ToString()); string ReprotNo = Request.QueryString["ReportNo"].ToString(); string CompanyCD = UserInfo.CompanyCD; /*读取数据*/ DataTable dtDetail = new DataTable(); DataTable dt = XBase.Business.Office.StorageManager.CheckReportBus.GetReportInfo(ID); dtDetail = XBase.Business.Office.StorageManager.CheckReportBus.GetDetailInfo(ID); /*绑定RPT*/ if (dt != null) { /*加载主报表*/ this.CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageCheckReport.rpt")); CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.QualityCheckReport")); /*加载子报表*/ ReportDocument rdDetail = new ReportDocument(); if (dtDetail.Rows.Count > 0) { rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageCheckReportDetail.rpt"]; rdDetail.SetDataSource(dtDetail); } //绑定数据 CrystalReportSource1.ReportDocument.SetDataSource(dt); CrystalReportSource1.DataBind(); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; this.CrystalReportSource1.ReportDocument.SetParameterValue("Creator", userInfo.UserName); this.CrystalReportViewer1.ReportSource = CrystalReportSource1; } }
//public void DataBindToYear() //{ // string year = string.Empty; // int yearTemp = DateTime.Now.Year - 10; // for (int i = 0; i <= 30; i++) // { // ddlYear.Items.Add(new ListItem((yearTemp + i).ToString() + "年度", (yearTemp + i).ToString())); // } // ddlYear.SelectedValue = DateTime.Now.Year.ToString(); //} //public void DataBindToMonth() //{ // string month = string.Empty; // int monthTemp = DateTime.Now.Month; // if (monthTemp < 10) // { // month = "0" + monthTemp.ToString(); // } // ddlEndMonth.SelectedValue = month; // this.ddlStartMonth.SelectedValue = month; //} //public void DataBindToDept() //{ // DataTable dt = PerformanceQueryBus.SearchDeptInfo(); // ddlDeptName.DataSource = dt; // ddlDeptName.DataTextField = "DeptName"; // ddlDeptName.DataValueField = "ID"; // ddlDeptName.DataBind(); // ddlDeptName.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0")); // ddlDeptName.SelectedValue = "0"; //} private void Search(string rectApplyID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtData = RectApplyBus.GetRectApplyInfoWithIDByReport(rectApplyID); DataTable dtSub = RectApplyBus.GetRectApplyDetailsInfoByReport(rectApplyID); ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/RectApplyEdit.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); ReportDocument rdDetail = CrystalReportSource1.ReportDocument.Subreports["RectApplyDetailReport.rpt"]; rdDetail.SetDataSource(dtSub); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; //CrystalReportViewer1.DataBind(); }
/*绑定信息*/ protected void BindInfo() { UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; /*接受参数*/ int ID = Convert.ToInt32(Request.QueryString["ID"].ToString()); string FromType = Request.QueryString["FromType"].ToString(); string ApplyNo = Request.QueryString["ApplyNo"].ToString(); string CompanyCD = UserInfo.CompanyCD; /*读取数据*/ DataTable dtDetail = new DataTable(); DataTable dt = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDB(ID); if (FromType.Trim() == "0") { dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "0"); } if (FromType == "1") { dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "1"); } if (FromType == "2") { dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "2"); } /*绑定RPT*/ if (dt != null) { /*加载主报表*/ if (FromType == "0") { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheck.rpt")); } if (FromType == "1") { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheckPur.rpt")); } if (FromType == "2") { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheckMan.rpt")); } /*加载子报表*/ ReportDocument rdDetail = new ReportDocument(); if (dtDetail.Rows.Count > 0) { if (FromType == "0") { rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail.rpt"]; rdDetail.SetDataSource(dtDetail); } if (FromType == "1") { rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail3.rpt"]; rdDetail.SetDataSource(dtDetail); } if (FromType == "2") { rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail2.rpt"]; rdDetail.SetDataSource(dtDetail); } } CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.QualityCheckApplay")); //绑定数据 CrystalReportSource1.ReportDocument.SetDataSource(dt); CrystalReportSource1.DataBind(); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; CrystalReportSource1.ReportDocument.SetParameterValue("Creator", userInfo.UserName); this.CrystalReportViewer1.ReportSource = CrystalReportSource1; } }
public void Search() { ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/EmployeeConditionMonthReport.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary")); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; EmployeeTestSearchModel searchModel = new EmployeeTestSearchModel(); string DeptID = ddlDeptName.SelectedValue; string dds = Request.Form.ToString(); string year = Request.Form["ddlTaskYear"] == null ? "" : Request.Form["ddlTaskYear"].ToString(); string month = Request.Form["ddlTaskNum"] == null ? "" : Request.Form["ddlTaskNum"].ToString(); string day = ""; if (month == "01" || month == "03" || month == "05" || month == "07" || month == "08" || month == "10" || month == "12") { day = "31"; } else if (month == "04" || month == "06" || month == "09" || month == "11") { day = "30"; } else { if (IsLeapYear(Convert.ToInt32(year))) { day = "29"; } else { day = "28"; } } string monthStartDate = year + "-" + month + "-" + "01"; string monthEndDate = year + "-" + month + "-" + day; //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Month"].Text = "\"" + "月份:" + year + "-" + month + "\""; DataTable dt = new DataTable(); DataColumn newCol1 = new DataColumn("UsedName"); //部门 DataColumn newCol2 = new DataColumn("Attachmentname"); //招聘人数 DataColumn newCol3 = new DataColumn("EmployeeName"); //面试人数 DataColumn newCol4 = new DataColumn("NameEn"); //报道人数 DataColumn newCol5 = new DataColumn("AccountNature"); //迟到人数 DataColumn newCol6 = new DataColumn("Height"); //早退人数 DataColumn newCol7 = new DataColumn("Weight"); //旷工次数 DataColumn newCol8 = new DataColumn("Sight"); //请假次数 DataColumn newCol9 = new DataColumn("EmployeeNo"); //迁调人数 DataColumn newCol10 = new DataColumn("CompanyCD"); //迁调人数 dt.Columns.Add(newCol1); dt.Columns.Add(newCol2); dt.Columns.Add(newCol3); dt.Columns.Add(newCol4); dt.Columns.Add(newCol5); dt.Columns.Add(newCol6); dt.Columns.Add(newCol7); dt.Columns.Add(newCol8); dt.Columns.Add(newCol9); dt.Columns.Add(newCol10); // 部门招聘人数 DataTable GetRequireNum = EmployeeTestBus.GetRequireNum(DeptID, monthStartDate, monthEndDate); // 部门面试人数 DataTable GetInterviewNum = EmployeeTestBus.GetInterviewNum(DeptID, monthStartDate, monthEndDate); // 部门报道人数 DataTable GetReportedNum = EmployeeTestBus.GetReportedNum(DeptID, monthStartDate, monthEndDate); // 部门迟到人数 DataTable GetLatedNum = EmployeeTestBus.GetLatedNum(DeptID, monthStartDate, monthEndDate); // 部门早退人数 DataTable GetLeaveEarlyNum = EmployeeTestBus.GetLeaveEarlyNum(DeptID, monthStartDate, monthEndDate); // 部门旷工人次 DataTable GetAbsenteeismNum = EmployeeTestBus.GetAbsenteeismNum(DeptID, monthStartDate, monthEndDate); // 部门请假次数 DataTable GetLeaveNum = EmployeeTestBus.GetLeaveNum(DeptID, monthStartDate, monthEndDate); // 部门调出人数 DataTable GetDeptOutNum = EmployeeTestBus.GetDeptOutNum(DeptID, monthStartDate, monthEndDate); // 部门调入人数 DataTable GetDeptInNum = EmployeeTestBus.GetDeptInNum(DeptID, monthStartDate, monthEndDate); // 部门离职人数 DataTable GetSeparationNum = EmployeeTestBus.GetSeparationNum(DeptID, monthStartDate, monthEndDate); //获取某公司的所有部门 DataTable dtData = EmployeeTestBus.GetDeptInfo(DeptID); if (dtData.Rows.Count > 0) { for (int i = 0; i < dtData.Rows.Count; i++) { DataRow sk = dt.NewRow(); string deptName = dtData.Rows[i]["DeptName"] == null ? "" : dtData.Rows[i]["DeptName"].ToString(); sk["UsedName"] = deptName; string ID = dtData.Rows[i]["ID"] == null ? "" : dtData.Rows[i]["ID"].ToString(); // 部门招聘人数 DataTable GetRequireNum2 = GetNewDataTable(GetRequireNum, "applyDept='" + ID + "'"); if (GetRequireNum2.Rows.Count > 0) { sk["Attachmentname"] = GetRequireNum2.Rows[0]["PersonCount"] == null ? "" : GetRequireNum2.Rows[0]["PersonCount"].ToString(); } // 部门面试人数 DataTable GetInterviewNum2 = GetNewDataTable(GetInterviewNum, "DeptID='" + ID + "'"); if (GetInterviewNum2.Rows.Count > 0) { sk["EmployeeName"] = GetInterviewNum2.Rows[0]["InterviewNum"] == null ? "" : GetInterviewNum2.Rows[0]["InterviewNum"].ToString(); } // 部门报道人数 DataTable GetReportedNum2 = GetNewDataTable(GetReportedNum, "DeptID='" + ID + "'"); if (GetReportedNum2.Rows.Count > 0) { sk["NameEn"] = GetReportedNum2.Rows[0]["ReportedNum"] == null ? "" : GetReportedNum2.Rows[0]["ReportedNum"].ToString(); } // 部门迟到人数 DataTable GetLatedNum2 = GetNewDataTable(GetLatedNum, "DeptID='" + ID + "'"); if (GetLatedNum2.Rows.Count > 0) { sk["AccountNature"] = GetLatedNum2.Rows[0]["DelayManCount"] == null ? "" : GetLatedNum2.Rows[0]["DelayManCount"].ToString(); } // 部门早退人数 DataTable GetLeaveEarlyNum2 = GetNewDataTable(GetLeaveEarlyNum, "DeptID='" + ID + "'"); if (GetLeaveEarlyNum2.Rows.Count > 0) { sk["Height"] = GetLeaveEarlyNum2.Rows[0]["DelayManCount"] == null ? "" : GetLeaveEarlyNum2.Rows[0]["DelayManCount"].ToString(); } // 部门旷工人次 DataTable GetAbsenteeismNum2 = GetNewDataTable(GetAbsenteeismNum, "DeptID='" + ID + "'"); if (GetAbsenteeismNum2.Rows.Count > 0) { sk["Weight"] = GetAbsenteeismNum2.Rows[0]["Absentee"] == null ? "" : GetAbsenteeismNum2.Rows[0]["Absentee"].ToString(); } // 部门请假次数 DataTable GetLeaveNum2 = GetNewDataTable(GetLeaveNum, "DeptID='" + ID + "'"); if (GetLeaveNum2.Rows.Count > 0) { sk["Sight"] = GetLeaveNum2.Rows[0]["leaveCount"] == null ? "" : GetLeaveNum2.Rows[0]["leaveCount"].ToString(); } //部门迁出人数 DataTable GetDeptOutNum2 = GetNewDataTable(GetDeptOutNum, "NowDeptID='" + ID + "'"); string outNum = "0"; if (GetDeptOutNum2.Rows.Count > 0) { outNum = GetDeptOutNum2.Rows[0]["countQian"] == null ? "0" : GetDeptOutNum2.Rows[0]["countQian"].ToString(); } //部门迁入人数 DataTable GetDeptInNum2 = GetNewDataTable(GetDeptInNum, "NewDeptID='" + ID + "'"); string intNum = "0"; if (GetDeptInNum2.Rows.Count > 0) { intNum = GetDeptInNum2.Rows[0]["countQian"] == null ? "0" : GetDeptInNum2.Rows[0]["countQian"].ToString(); } string qianNum = (Convert.ToInt32(outNum) + Convert.ToInt32(intNum)).ToString(); if (qianNum == "0") { qianNum = ""; } sk["EmployeeNo"] = qianNum; // 部门离职人次 DataTable GetSeparationNum2 = GetNewDataTable(GetSeparationNum, "DeptID='" + ID + "'"); if (GetSeparationNum2.Rows.Count > 0) { sk["CompanyCD"] = GetSeparationNum2.Rows[0]["separateNum"] == null ? "" : GetSeparationNum2.Rows[0]["separateNum"].ToString(); } dt.Rows.Add(sk); } } CrystalReportSource1.ReportDocument.SetDataSource(dt); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlDeptName.SelectedValue != "0") { searchModel.QuarterID = ddlDeptName.SelectedValue; } if (this.ddlStartMonth.SelectedValue != "0")//起始月份 { searchModel.AdminLevel = ddlStartMonth.SelectedValue; } if (this.ddlEndMonth.SelectedValue != "0")//结束月份 { searchModel.AdminLevelName = ddlEndMonth.SelectedValue; } if (this.ddlYear.SelectedValue != "0")//结束月份 { searchModel.UnitPrice = ddlYear.SelectedValue; } searchModel.UsedStatus = txtSearchEmployee.Value; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtNewTable = SalaryStandardBus.SearchSalaryDetailsReport(searchModel); DataTable dtData = new DataTable(); dtData.Columns.Add("WorkMoney"); //部门 dtData.Columns.Add("CompanyCD"); //月份 dtData.Columns.Add("EmployeeID"); //人员编号 dtData.Columns.Add("ReprotNo"); //人员姓名 dtData.Columns.Add("FixedMoney"); //岗位 dtData.Columns.Add("TimeMoney"); //职等 dtData.Columns.Add("AllGetMoney"); //应发工资 dtData.Columns.Add("AllKillMoney"); //应扣工资 dtData.Columns.Add("SalaryMoney"); //实发工资 for (int i = 0; i < dtNewTable.Rows.Count; i++) { DataTable dt = SalaryStandardBus.GetEmployeeDetailsOutTime(dtNewTable.Rows[i]["EmployeeID"] == null ? "" : dtNewTable.Rows[i]["EmployeeID"].ToString(), dtNewTable.Rows[i]["DeptID"] == null ? "" : dtNewTable.Rows[i]["DeptID"].ToString(), dtNewTable.Rows[i]["ReprotNo"] == null ? "" : dtNewTable.Rows[i]["ReprotNo"].ToString()); DataRow newRow = dtData.NewRow(); newRow["WorkMoney"] = dt.Rows[0]["DeptName"] == null ? "" : dt.Rows[0]["DeptName"].ToString(); newRow["CompanyCD"] = dtNewTable.Rows[i]["ReportMonth"] == null ? "" : dtNewTable.Rows[i]["ReportMonth"].ToString(); newRow["EmployeeID"] = dt.Rows[0]["EmployeeName"] == null ? "" : dt.Rows[0]["EmployeeName"].ToString(); newRow["FixedMoney"] = dt.Rows[0]["TimeMoney"] == null ? "" : dt.Rows[0]["TimeMoney"].ToString(); dtData.Rows.Add(newRow); } ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryWorkByTime.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
public void Search() { ReportDocument oRpt = new ReportDocument(); if (chkType1.Checked) { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLT.rpt")); } if (chkType2.Checked) { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLTBing.rpt")); } if (chkType3.Checked) { CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLTZhe.rpt")); } // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary")); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; PerformanceTaskModel searchModel = new PerformanceTaskModel(); if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1)//部门 { searchModel.SummaryDate = ddlDeptName.SelectedValue; } if (ddlTaskFlag.SelectedIndex != 0) { searchModel.TaskFlag = ddlTaskFlag.SelectedValue; //考核期间类型 } if (ddlTestNo.SelectedValue != "0" && ddlTestNo.SelectedIndex != -1) { searchModel.TaskNo = ddlTestNo.SelectedValue; //考核任务编号 } if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1) { searchModel.CompleteDate = this.ddlPerType.SelectedValue; //考核类型 } if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5") { if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1) { searchModel.TaskNum = ddlTaskNum.SelectedValue; //考核期间 } } if (this.ddlLevelType.SelectedIndex != 0) { searchModel.Summaryer = ddlLevelType.SelectedValue; //考核等级 } // if (Request.QueryString["AdviceType"] != "0") // searchModel.Title = Request.QueryString["AdviceType"];//考核建议 if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1) { searchModel.TaskDate = ddlTaskYear.SelectedValue; //考核建议 } // if (!string.IsNullOrEmpty(Request.QueryString["EmployeeID"])) // searchModel.EditFlag = Request.QueryString["EmployeeID"];//被考核人 searchModel.CompanyCD = userInfo.CompanyCD; //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "全部" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; DataTable dtData = PerformanceQueryBus.SearchDetailsInfoByLT(searchModel); if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + ddlDeptName.Items[ddlDeptName.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + "全部" + "\""; } if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + ddlPerType.Items[ddlPerType.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + "全部" + "\""; } if (ddlTaskFlag.SelectedIndex != 0) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + ddlTaskFlag.Items[ddlTaskFlag.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + "全部" + "\""; } if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5") { if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1) { if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "所有年份" + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\""; } } } else { if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + "\""; } } CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
protected void lnkDownloadPrv_Click(object sender, EventArgs e) { string oonum = ((System.Web.UI.WebControls.GridViewRow)((((System.Web.UI.Control)(sender)).Parent).Parent)).Cells[7].Text; string propno = ((System.Web.UI.WebControls.GridViewRow)((((System.Web.UI.Control)(sender)).Parent).Parent)).Cells[3].Text; string sql = "SELECT m.sno, p.OONUM AS oonum1, to_char(p.OODATE,'dd-MM-yyyy') AS oodate1, '1' AS notes, p.ENDONUM AS endono,10 AS fsize," + "(SELECT COUNT(*) FROM cadre.propcadrmap WHERE propno = 163 ) AS TotCount," + "(SELECT COUNT(*) FROM cadre.propcadrmap WHERE status = 'P' AND propno = 163 ) AS PCount," + "pshr.get_fullname(e.empid) AS fullname," + "TO_CHAR(e.empid) AS empid," + "TO_CHAR(e.dob,'dd-mm-yyyy') AS dob," + "pshr.get_post(e.cloccode) AS old_work_loc," + "e.cloccode AS old_work_loccode," + "pshr.get_desg(e.cdesgcode) AS old_work_desg," + "e.cdesgcode AS old_work_desgcode," + "DECODE(m.rowno,0,pshr.get_post(e.cloccode), pshr.get_post(cadre.get_lcode_rno(m.rowno))) AS old_pc_loc," + "DECODE(m.rowno,0,e.cloccode, cadre.get_lcode_rno(m.rowno)) AS old_pc_loccode," + "DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.rowno))) AS old_pc_desg," + "DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.rowno)) AS old_pc_desgcode," + "DECODE(m.rowno,0,'0', cadre.get_indx_rno(m.rowno)) AS old_pc_indx," + "cadre.get_org_plants(m.cloccode) AS new_work_loc," + "m.cloccode AS new_work_loccode," + "pshr.get_desg(m.cdesgcode) AS new_work_desg," + "m.cdesgcode AS new_work_desgcode," + "DECODE(LENGTH(m.proposed_rowno),9,pshr.get_post(m.proposed_rowno), cadre.get_org_plants(cadre.get_lcode_rno(m.proposed_rowno))) AS new_pc_loc," + "DECODE(LENGTH(m.proposed_rowno),9,m.proposed_rowno, cadre.get_lcode_rno(m.proposed_rowno)) AS new_pc_loccode," + "DECODE(m.proposed_rowno,0,pshr.get_desg(m.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg," + "DECODE(m.proposed_rowno,0,m.cdesgcode, cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode," + "cadre.get_indx_rno(m.proposed_rowno) AS new_pc_indx," + "(select data from cadre.bignotes where name = p.bignote) AS BIGNOTE," + "(select data from cadre.bigcc where name = p.bigcc) AS BIGCC," + "m.sysremarks" + "|| m.remarks AS remarks," + "'G' AS grp," + "m.propno," + "m.prvcomment," + "TO_CHAR(m.newempid) AS newempid," + "m.status," + "m.disp_left," + "m.disp_right," + "pshr.get_soccat(e.empid) AS categ " + "FROM pshr.empperso e," + "cadre.propcadrmap m," + "cadre.tp_proposals p " + "WHERE e.empid =m.empid " + "AND m.propno = p.pno " + "AND m.status IS NOT NULL " + "AND M.STATUS NOT IN ('S','V') " + "AND m.propno =" + propno + " " + "AND m.cloccode IS NOT NULL " + "ORDER BY sno"; System.Data.DataSet ds = OraDBConnection.GetData(sql); string pdfPath; pdfPath = Server.MapPath("office_orders\\" + oonum.Replace("\\", "").Replace("/", "") + "-BEG-I.pdf"); CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptposttrans_pc.rpt"); CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]); CrystalReportSource1.DataBind(); CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath); Utils.DownloadFile(pdfPath); }
private void MakeReport() { string oonum = "-"; string oodate = "-"; string notes = ""; if (Session.Contents["save"].ToString() == "YES") { oonum = Session.Contents["oonum"].ToString(); oodate = Session.Contents["oodate"].ToString(); } //notes = Session.Contents["notes"].ToString(); notes = "1"; string sql = "select m.sno,'" + oonum + "' as oonum1, '" + oodate + "' as oodate1, '" + notes + "' as notes," + " pshr.get_fullname(e.empid),e.empid,e.dob," + "pshr.get_post(e.cloccode) as old_work_loc,e.cloccode as old_work_loccode,pshr.get_desg(e.cdesgcode) as old_work_desg," + "e.cdesgcode as old_work_desgcode," + "DECODE(m.rowno,0,pshr.get_post(e.cloccode), pshr.get_post(cadre.get_lcode_rno(m.rowno))) AS old_pc_loc," + " DECODE(m.rowno,0,e.cloccode, cadre.get_lcode_rno(m.rowno)) AS old_pc_loccode," + " DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.rowno))) AS old_pc_desg, " + " DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.rowno)) AS old_pc_desgcode, " + " DECODE(m.rowno,0,'0', cadre.get_indx_rno(m.rowno)) AS old_pc_indx, " + //pshr.get_post(cadre.get_lcode_rno(m.rowno)) as old_pc_loc," + //"cadre.get_lcode_rno(m.rowno) as old_pc_loccode,pshr.get_desg(cadre.get_dcode_rno(m.rowno)) as old_pc_desg," + //"cadre.get_dcode_rno(m.rowno) as old_pc_desgcode,cadre.get_indx_rno(m.rowno) as old_pc_indx, " pshr.get_post(m.cloccode) as new_work_loc," + "m.cloccode as new_work_loccode,pshr.get_desg(m.cdesgcode) as new_work_desg,m.cdesgcode as new_work_desgcode," + //"pshr.get_post(cadre.get_lcode_rno(m.proposed_rowno)) as new_pc_loc,cadre.get_lcode_rno(m.proposed_rowno) as new_pc_loccode," + "decode(length(m.proposed_rowno),9,pshr.get_post(m.proposed_rowno), pshr.get_post(cadre.get_lcode_rno(m.proposed_rowno))) AS new_pc_loc," + "decode(length(m.proposed_rowno),9,m.proposed_rowno, cadre.get_lcode_rno(m.proposed_rowno)) AS new_pc_loccode," + " DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg, " + " DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode, " + //"decode(length(m.proposed_rowno),9,pshr.get_desg(cadre.get_dcode_rno(m.rowno)), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg,"+ //"decode(length(m.proposed_rowno),9,cadre.get_dcode_rno(m.rowno), cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode,"+ ////"pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno)) as new_pc_desg,cadre.get_dcode_rno(m.proposed_rowno) as new_pc_desgcode," + "cadre.get_indx_rno(m.proposed_rowno) as new_pc_indx, m.remarks,'G' as grp,m.proposalno from pshr.empperso e, cadre.cadrmap m where e.empid=m.empid and m.status is not null " + "order by sno"; OraDBConnection oraCn = new OraDBConnection(); System.Data.DataSet ds = OraDBConnection.GetData(sql); string pdfPath; if (Session.Contents["save"].ToString() == "YES") { pdfPath = Server.MapPath("office_orders\\" + oonum + "\\BEG-I" + oodate + ".pdf"); } else { //get sysdate string sysdate = OraDBConnection.GetScalar("select to_char(sysdate,'dd-mm-yyyy') from dual"); string systime = OraDBConnection.GetScalar("select to_char(sysdate,'hh-mm') from dual"); pdfPath = Server.MapPath("office_orders\\" + sysdate + systime + ".pdf"); } CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptposttrans.rpt"); CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]); CrystalReportSource1.DataBind(); CrystalReportViewer1.ReportSource = CrystalReportSource1; CrystalReportViewer1.DataBind(); System.Data.DataSet ds6; string sql3 = "select * from cadre.notes_proposal_person where ccnum > 0 order by sno"; ds6 = OraDBConnection.GetData(sql3); CrystalReportSource1.ReportDocument.Subreports["notes"].SetDataSource(ds6.Tables[0]); CrystalReportSource1.DataBind(); System.Data.DataSet ds5; string sql2 = "select * from cadre.cclist_proposal_person where ccnum > 0 order by sno"; ds5 = OraDBConnection.GetData(sql2); CrystalReportSource1.ReportDocument.Subreports["cclists"].SetDataSource(ds5.Tables[0]); CrystalReportSource1.DataBind(); CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath); DownloadFile(pdfPath); }