/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_InOutReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell27 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell30 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell29 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell28 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell36 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell32 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell33 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell34 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell35 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell37 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 15.41665F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(36.45825F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(846.5417F, 15.41665F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell27, this.xrTableCell30, this.xrTableCell29, this.xrTableCell28, this.xrTableCell20, this.xrTableCell19, this.xrTableCell5, this.xrTableCell8, this.xrTableCell10, this.xrTableCell9, this.xrTableCell11, this.xrTableCell12 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell27 // this.xrTableCell27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Code") }); this.xrTableCell27.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell27.Name = "xrTableCell27"; this.xrTableCell27.StylePriority.UseFont = false; this.xrTableCell27.Text = "xrTableCell27"; this.xrTableCell27.Weight = 0.4999997711181639; // // xrTableCell30 // this.xrTableCell30.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell30.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell30.Name = "xrTableCell30"; this.xrTableCell30.StylePriority.UseFont = false; this.xrTableCell30.Text = "xrTableCell30"; this.xrTableCell30.Weight = 0.96874988555908215; this.xrTableCell30.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell30_BeforePrint); // // xrTableCell29 // this.xrTableCell29.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Shift_Name") }); this.xrTableCell29.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell29.Name = "xrTableCell29"; this.xrTableCell29.Text = "xrTableCell29"; this.xrTableCell29.Weight = 1.0208333206176756; // // xrTableCell28 // this.xrTableCell28.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OnDuty_Time") }); this.xrTableCell28.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell28.Name = "xrTableCell28"; this.xrTableCell28.Text = "xrTableCell28"; this.xrTableCell28.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell28.Weight = 0.63541610717773434; // // xrTableCell20 // this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OffDuty_Time") }); this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.Text = "xrTableCell20"; this.xrTableCell20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell20.Weight = 0.67456237792968743; // // xrTableCell19 // this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.In_Time") }); this.xrTableCell19.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell19.Weight = 0.69382476806640625; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Out_Time") }); this.xrTableCell5.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell5.Weight = 0.62500030517578153; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.LateMin") }); this.xrTableCell8.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 0.52398162841796925; this.xrTableCell8.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell8_BeforePrint); // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.EarlyMin") }); this.xrTableCell10.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell10.Weight = 0.57291687011718739; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.EffectiveWork_Min") }); this.xrTableCell9.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.Text = "xrTableCell9"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell9.Weight = 0.5723724365234375; this.xrTableCell9.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell9_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OverTime_Min") }); this.xrTableCell11.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 0.88281188964843693; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell12 // this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Field1") }); this.xrTableCell12.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.Text = "xrTableCell12"; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell12.Weight = 0.794948733033147; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 18.54165F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(36.45834F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(846.5417F, 18.54165F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell21, this.xrTableCell7, this.xrTableCell6, this.xrTableCell2, this.xrTableCell4, this.xrTableCell1, this.xrTableCell22, this.xrTableCell24, this.xrTableCell25, this.xrTableCell23, this.xrTableCell26, this.xrTableCell3 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell21 // this.xrTableCell21.Name = "xrTableCell21"; this.xrTableCell21.Text = "ID"; this.xrTableCell21.Weight = 0.43482135264705046; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.84246639449167837; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "Shift"; this.xrTableCell6.Weight = 0.88776053973238311; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "On Duty "; this.xrTableCell2.Weight = 0.55258535928846564; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "Off Duty "; this.xrTableCell4.Weight = 0.58662782725143692; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "In Time"; this.xrTableCell1.Weight = 0.60338002583602923; // // xrTableCell22 // this.xrTableCell22.Name = "xrTableCell22"; this.xrTableCell22.Text = "Out Time"; this.xrTableCell22.Weight = 0.54352680981884849; // // xrTableCell24 // this.xrTableCell24.Name = "xrTableCell24"; this.xrTableCell24.Text = "Late"; this.xrTableCell24.Weight = 0.45567689520649723; // // xrTableCell25 // this.xrTableCell25.Name = "xrTableCell25"; this.xrTableCell25.Text = "Early"; this.xrTableCell25.Weight = 0.49823307924366106; // // xrTableCell23 // this.xrTableCell23.Name = "xrTableCell23"; this.xrTableCell23.Text = "Work"; this.xrTableCell23.Weight = 0.49775962447414274; // // xrTableCell26 // this.xrTableCell26.Name = "xrTableCell26"; this.xrTableCell26.Text = "Overtime"; this.xrTableCell26.Weight = 0.76773174494671226; // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "Status"; this.xrTableCell3.Weight = 0.69132030305227632; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(587.7919F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(36.45825F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 77F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(36.45833F, 5F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(846.5417F, 72F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(4.041668F, 27F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(208.7263F, 52F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(450.1771F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(743.5417F, 2F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 47.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(4.041668F, 2F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 15.625F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(36.45825F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(846.5418F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.3645834350585937; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Code") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "[Emp_Code]"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.StylePriority.UseBorders = false; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 6.3447381591796876; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable5 }); this.GroupFooter1.HeightF = 20F; this.GroupFooter1.Name = "GroupFooter1"; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(36.45831F, 0F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5 }); this.xrTable5.SizeF = new System.Drawing.SizeF(846.5417F, 20F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell36, this.xrTableCell32, this.xrTableCell33, this.xrTableCell34, this.xrTableCell35, this.xrTableCell37 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell36 // this.xrTableCell36.Name = "xrTableCell36"; this.xrTableCell36.StylePriority.UseTextAlignment = false; this.xrTableCell36.Text = "Total "; this.xrTableCell36.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell36.Weight = 2.0018547344583935; // // xrTableCell32 // this.xrTableCell32.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell32.Name = "xrTableCell32"; this.xrTableCell32.StylePriority.UseTextAlignment = false; this.xrTableCell32.Text = "xrTableCell32"; this.xrTableCell32.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell32.Weight = 0.20493458428833339; this.xrTableCell32.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell32_BeforePrint); // // xrTableCell33 // this.xrTableCell33.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell33.Name = "xrTableCell33"; this.xrTableCell33.StylePriority.UseTextAlignment = false; this.xrTableCell33.Text = "xrTableCell33"; this.xrTableCell33.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell33.Weight = 0.22407351670249165; this.xrTableCell33.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell33_BeforePrint); // // xrTableCell34 // this.xrTableCell34.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell34.Name = "xrTableCell34"; this.xrTableCell34.StylePriority.UseTextAlignment = false; this.xrTableCell34.Text = "xrTableCell34"; this.xrTableCell34.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell34.Weight = 0.22386105546104113; this.xrTableCell34.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell34_BeforePrint); // // xrTableCell35 // this.xrTableCell35.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell35.Name = "xrTableCell35"; this.xrTableCell35.StylePriority.UseTextAlignment = false; this.xrTableCell35.Text = "xrTableCell35"; this.xrTableCell35.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell35.Weight = 0.345276499085476; this.xrTableCell35.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell35_BeforePrint); // // xrTableCell37 // this.xrTableCell37.Name = "xrTableCell37"; this.xrTableCell37.Weight = 0.3109128341579464; // // Att_InOutReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(7, 0, 0, 0); this.PageWidth = 900; this.PaperKind = System.Drawing.Printing.PaperKind.Custom; this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_EarlyOutReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable4 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 16.66667F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(678.0001F, 16.66667F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell8, this.xrTableCell10, this.xrTableCell11, this.xrTableCell12 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell5.Weight = 0.93953195788864219; this.xrTableCell5.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell5_BeforePrint); // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Shift_Name") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 1.7769299886123116; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OffDuty_Time") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell10.Weight = 1.1770818923406523; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Out_Time") }); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 1.3810922162417518; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell12 // this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.EarlyMin") }); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.Text = "xrTableCell12"; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell12.Weight = 1.5053649970010559; this.xrTableCell12.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell12_BeforePrint); // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 15.41665F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(678F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell1, this.xrTableCell2, this.xrTableCell4, this.xrTableCell6 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.StylePriority.UseBorders = false; this.xrTableRow1.Weight = 1; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.81705725213459512; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Shift Name"; this.xrTableCell1.Weight = 1.5452948677508345; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Off Duty Time"; this.xrTableCell2.Weight = 1.0236415056529262; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "Out Time"; this.xrTableCell4.Weight = 1.2010566238528198; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "Early Hour"; this.xrTableCell6.Weight = 1.3091295931577713; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(382.7918F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(678F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(2.000003F, 28.00001F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(122.9167F, 53.00001F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(450.1771F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(576F, 2F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(2F, 2F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 15.625F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(678.0001F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.3645834350585937; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 4.6593206787109374; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable5, this.xrTable4 }); this.GroupFooter1.HeightF = 16.04166F; this.GroupFooter1.Name = "GroupFooter1"; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5 }); this.xrTable5.SizeF = new System.Drawing.SizeF(389.3544F, 16.04166F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3, this.xrTableCell20 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell3 // this.xrTableCell3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseBorders = false; this.xrTableCell3.StylePriority.UseFont = false; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "Early Count : "; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.xrTableCell3.Weight = 1.5009246106343523; // // xrTableCell20 // this.xrTableCell20.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.StylePriority.UseBorders = false; this.xrTableCell20.StylePriority.UseFont = false; this.xrTableCell20.StylePriority.UseTextAlignment = false; this.xrTableCell20.Text = "xrTableCell19"; this.xrTableCell20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell20.Weight = 0.65037202986840026; this.xrTableCell20.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell20_BeforePrint); // // xrTable4 // this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable4.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(389.3544F, 0F); this.xrTable4.Name = "xrTable4"; this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4 }); this.xrTable4.SizeF = new System.Drawing.SizeF(288.6457F, 16.04166F); this.xrTable4.StylePriority.UseBorders = false; this.xrTable4.StylePriority.UseFont = false; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell9, this.xrTableCell19 }); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1; // // xrTableCell9 // this.xrTableCell9.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell9.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseBorders = false; this.xrTableCell9.StylePriority.UseFont = false; this.xrTableCell9.Text = "Early Hours :"; this.xrTableCell9.Weight = 0.76309374871698588; // // xrTableCell19 // this.xrTableCell19.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell19.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.StylePriority.UseBorders = false; this.xrTableCell19.StylePriority.UseFont = false; this.xrTableCell19.StylePriority.UseTextAlignment = false; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell19.Weight = 0.83175811260262689; this.xrTableCell19.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell19_BeforePrint); // // Att_EarlyOutReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(100, 67, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } dtFilter = new DataView(dtFilter, "Is_Absent='True'", "", DataViewRowState.CurrentRows).ToTable(); string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Absent Report" + " From " + FromDate.ToString(objSys.SetDateFormat()) + " To " + ToDate.ToString(objSys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtFilter; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_PartialViolationReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable4 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 16.66667F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(804.9999F, 16.66667F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell8, this.xrTableCell10, this.xrTableCell11, this.xrTableCell24, this.xrTableCell12, this.xrTableCell25, this.xrTableCell26 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell5.Weight = 0.93953195788864219; this.xrTableCell5.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell5_BeforePrint); // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Shift_Name") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 1.5500508743817512; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OnDuty_Time") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell10.Weight = 1.0289622366005617; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OffDuty_Time") }); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 0.97484012826175037; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell24 // this.xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.In_Time") }); this.xrTableCell24.Name = "xrTableCell24"; this.xrTableCell24.Text = "xrTableCell24"; this.xrTableCell24.Weight = 0.69791714189135134; // // xrTableCell12 // this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Out_Time") }); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.Text = "xrTableCell12"; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell12.Weight = 0.76562438165863111; this.xrTableCell12.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell12_BeforePrint); // // xrTableCell25 // this.xrTableCell25.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Partial_Min") }); this.xrTableCell25.Name = "xrTableCell25"; this.xrTableCell25.StylePriority.UseTextAlignment = false; this.xrTableCell25.Text = "xrTableCell25"; this.xrTableCell25.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell25.Weight = 1.0390630137417478; // // xrTableCell26 // this.xrTableCell26.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Partial_Violation_Min") }); this.xrTableCell26.Name = "xrTableCell26"; this.xrTableCell26.StylePriority.UseTextAlignment = false; this.xrTableCell26.Text = "xrTableCell26"; this.xrTableCell26.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell26.Weight = 1.0540094550204204; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 15.41665F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(805F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell1, this.xrTableCell2, this.xrTableCell4, this.xrTableCell6, this.xrTableCell21, this.xrTableCell22, this.xrTableCell23 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.81705725213459512; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Shift Name"; this.xrTableCell1.Weight = 1.3479910369971919; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "On Duty Time"; this.xrTableCell2.Weight = 0.89482935681425535; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "Off Duty Time"; this.xrTableCell4.Weight = 0.8477636380848026; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "In Time"; this.xrTableCell6.Weight = 0.60693812253107948; // // xrTableCell21 // this.xrTableCell21.Name = "xrTableCell21"; this.xrTableCell21.Text = "Out Time"; this.xrTableCell21.Weight = 0.66581987693541711; // // xrTableCell22 // this.xrTableCell22.Name = "xrTableCell22"; this.xrTableCell22.Text = "Partial Minute"; this.xrTableCell22.Weight = 0.90361340036795379; // // xrTableCell23 // this.xrTableCell23.Name = "xrTableCell23"; this.xrTableCell23.Text = "Violation Minute"; this.xrTableCell23.Weight = 0.91661319327832724; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(509.7918F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(7.947286E-06F, 0F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(804.9998F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(5F, 27F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(125F, 52F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(534.359F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(700F, 2F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(5F, 2F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 15.625F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(804.9998F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.3645834350585937; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 5.9293182373046873; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable5, this.xrTable4 }); this.GroupFooter1.HeightF = 16.66667F; this.GroupFooter1.Name = "GroupFooter1"; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5 }); this.xrTable5.SizeF = new System.Drawing.SizeF(478.9378F, 16.04166F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3, this.xrTableCell20 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell3 // this.xrTableCell3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseBorders = false; this.xrTableCell3.StylePriority.UseFont = false; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "Violation Count :"; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.xrTableCell3.Weight = 3.7560910587904126; // // xrTableCell20 // this.xrTableCell20.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.StylePriority.UseBorders = false; this.xrTableCell20.StylePriority.UseFont = false; this.xrTableCell20.StylePriority.UseTextAlignment = false; this.xrTableCell20.Text = "xrTableCell19"; this.xrTableCell20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell20.Weight = 1.0332862269671472; this.xrTableCell20.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell20_BeforePrint); // // xrTable4 // this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable4.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(478.9378F, 0F); this.xrTable4.Name = "xrTable4"; this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4 }); this.xrTable4.SizeF = new System.Drawing.SizeF(326.0622F, 16.04166F); this.xrTable4.StylePriority.UseBorders = false; this.xrTable4.StylePriority.UseFont = false; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell9, this.xrTableCell19 }); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1; // // xrTableCell9 // this.xrTableCell9.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell9.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseBorders = false; this.xrTableCell9.StylePriority.UseFont = false; this.xrTableCell9.Text = "Total Violation Minute :"; this.xrTableCell9.Weight = 1.804211840108658; // // xrTableCell19 // this.xrTableCell19.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell19.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.StylePriority.UseBorders = false; this.xrTableCell19.StylePriority.UseFont = false; this.xrTableCell19.StylePriority.UseTextAlignment = false; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell19.Weight = 1.4564105700477534; this.xrTableCell19.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell19_BeforePrint); // // Att_PartialViolaitonReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(30, 6, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } DataTable dtReport = dtFilter.Clone(); for (int i = 0; i < dtFilter.Rows.Count; i++) { if (dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { // dtFilter.Rows[i]["Field1"] = "NA"; // dtReport.ImportRow(dtFilter.Rows[i]); } else if (!dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { if (!Convert.ToBoolean(dtFilter.Rows[i]["Is_Leave"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Holiday"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Week_Off"].ToString())) { dtFilter.Rows[i]["Field1"] = "Out"; dtReport.ImportRow(dtFilter.Rows[i]); } } else if (dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && !dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { if (!Convert.ToBoolean(dtFilter.Rows[i]["Is_Leave"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Holiday"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Week_Off"].ToString())) { dtFilter.Rows[i]["Field1"] = "In"; dtReport.ImportRow(dtFilter.Rows[i]); } } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("In Out Exception Report" + " From " + FromDate.ToString(objSys.SetDateFormat()) + " To " + ToDate.ToString(objSys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtReport; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_EmployeeReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.sp_Set_Employee_Holiday_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Set_Employee_Holiday_ReportTableAdapter(); this.sp_Set_Att_Employee_Leave_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Set_Att_Employee_Leave_ReportTableAdapter(); this.sp_Att_AttendanceLog_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceLog_ReportTableAdapter(); this.sp_Att_AttendanceLog_ReportTableAdapter2 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceLog_ReportTableAdapter(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.set_EmployeeInformation_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Set_EmployeeInformation_ReportTableAdapter(); this.xrControlStyle1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 14.99999F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(814.0001F, 14.99999F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell6, this.xrTableCell13, this.xrTableCell14, this.xrTableCell8, this.xrTableCell9, this.xrTableCell4 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Emp_Code") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "Leave Name"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell5.Weight = 0.477216631091147; // // xrTableCell6 // this.xrTableCell6.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Emp_Name") }); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.StylePriority.UseBorders = false; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.Text = "Total Leave"; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell6.Weight = 1.2205727125614305; // // xrTableCell13 // this.xrTableCell13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Brand_Name") }); this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.StylePriority.UseTextAlignment = false; this.xrTableCell13.Text = "xrTableCell13"; this.xrTableCell13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell13.Weight = 1.0575151463139298; // // xrTableCell14 // this.xrTableCell14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Location_Name") }); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = "xrTableCell14"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell14.Weight = 1.0236423799564949; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.CardNo") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "Paid Leave"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 1.3735097238348004; this.xrTableCell8.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell8_BeforePrint); // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Template3") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "Schedule Type"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell9.Weight = 1.0567946855367771; // // xrTableCell4 // this.xrTableCell4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Set_EmployeeInformation_Report.Template4") }); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.StylePriority.UseTextAlignment = false; this.xrTableCell4.Text = "xrTableCell4"; this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell4.Weight = 0.869643617423226; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 14.99999F; this.GroupHeader1.Name = "GroupHeader1"; this.GroupHeader1.StylePriority.UseTextAlignment = false; this.GroupHeader1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(814F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell11, this.xrTableCell7, this.xrTableCell10, this.xrTableCell12, this.xrTableCell1, this.xrTableCell2, this.xrTableCell3 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell11 // this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.Text = "ID"; this.xrTableCell11.Weight = 0.45576376830649179; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseTextAlignment = false; this.xrTableCell7.Text = "Name"; this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell7.Weight = 1.1657030073506496; // // xrTableCell10 // this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.Text = "Brand"; this.xrTableCell10.Weight = 1.0099751835675108; // // xrTableCell12 // this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.Text = "Location"; this.xrTableCell12.Weight = 0.97762577013119145; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Card Number"; this.xrTableCell1.Weight = 1.311765111493548; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.StylePriority.UseTextAlignment = false; this.xrTableCell2.Text = "Finger Enrolled"; this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell2.Weight = 1.0092874221756025; // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "Face Enrolled"; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell3.Weight = 0.830548874578634; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(518.7919F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75F; this.ReportHeader.Name = "ReportHeader"; // // sp_Set_Employee_Holiday_ReportTableAdapter1 // this.sp_Set_Employee_Holiday_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Set_Att_Employee_Leave_ReportTableAdapter1 // this.sp_Set_Att_Employee_Leave_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Att_AttendanceLog_ReportTableAdapter1 // this.sp_Att_AttendanceLog_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Att_AttendanceLog_ReportTableAdapter2 // this.sp_Att_AttendanceLog_ReportTableAdapter2.ClearBeforeFill = true; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // set_EmployeeInformation_ReportTableAdapter1 // this.set_EmployeeInformation_ReportTableAdapter1.ClearBeforeFill = true; // // xrControlStyle1 // this.xrControlStyle1.Name = "xrControlStyle1"; this.xrControlStyle1.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.xrControlStyle1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(1.589457E-05F, 0F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(814.0001F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(709.5F, 3.5F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(3F, 3F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(3F, 26F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(287.5F, 53F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(300F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // Att_EmployeeReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader }); this.DataAdapter = this.set_EmployeeInformation_ReportTableAdapter1; this.DataMember = "sp_Set_EmployeeInformation_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(14, 22, 0, 0); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.xrControlStyle1 }); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
public void GetReport() { if (Session["SelectedEmpId"] == null) { return; } Table1.Rows.Clear(); DataTable dtShortCode = (DataTable)Session["DtShortCode"]; //set color and short code string Normal = "P"; string Absent = (new DataView(dtShortCode, "Type='Absent'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ShortId"].ToString(); string WeekOff = (new DataView(dtShortCode, "Type='WeekOff'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ShortId"].ToString(); string Holiday = (new DataView(dtShortCode, "Type='Holiday'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ShortId"].ToString(); string Leave = "L"; string Normalcol = (new DataView(dtShortCode, "Type='Normal'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ColorCOde"].ToString(); string Absentcol = (new DataView(dtShortCode, "Type='Absent'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ColorCOde"].ToString(); string Leavecol = (new DataView(dtShortCode, "Type='Leave'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ColorCOde"].ToString(); string WeekOffcol = (new DataView(dtShortCode, "Type='WeekOff'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ColorCOde"].ToString(); string Holidaycol = (new DataView(dtShortCode, "Type='Holiday'", "", DataViewRowState.CurrentRows).ToTable()).Rows[0]["ColorCOde"].ToString(); DateTime dtFrom = new DateTime(Convert.ToInt32(txtYear.Text), Convert.ToInt32(ddlMonth.SelectedValue), 1); DateTime InitDtFrom = Convert.ToDateTime(dtFrom.ToString()); int totalDays = DateTime.DaysInMonth(Convert.ToInt32(txtYear.Text), Convert.ToInt32(ddlMonth.SelectedValue.ToString())); DateTime dtTo = dtFrom.AddDays(totalDays - 1); DateTime dtFromBK = dtFrom; AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(dtFrom.ToString()), Convert.ToDateTime(dtTo.ToString())); DataTable dtFilter = new DataTable(); if (Session["SelectedEmpId"].ToString() != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Session["SelectedEmpId"].ToString().Substring(0, Session["SelectedEmpId"].ToString().Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } else { rptdata.sp_Att_AttendanceRegister_Report.Rows.Clear(); } TableRow tr = new TableRow(); TableRow trWeekDay = new TableRow(); trWeekDay.Cells.Add(new TableCell()); trWeekDay.Cells.Add(new TableCell()); trWeekDay.Cells.Add(new TableCell()); TableCell tcSNO = new TableCell(); tcSNO.Text = "SNO"; tr.Cells.Add(tcSNO); TableCell tcId = new TableCell(); tcId.Wrap = false; tcId.Text = "ID"; tr.Cells.Add(tcId); TableCell tcName = new TableCell(); tcName.Wrap = false; tcName.Text = "Name"; tr.Cells.Add(tcName); int count = 1; while (count <= totalDays) { TableCell tcDay = new TableCell(); TableCell tcWeekDay = new TableCell(); tcDay.Text = count.ToString(); tcWeekDay.Text = dtFrom.AddDays(count - 1).DayOfWeek.ToString().Substring(0, 2).ToUpper(); tr.Cells.Add(tcDay); trWeekDay.Cells.Add(tcWeekDay); count++; } TableCell tcPresent = new TableCell(); tcPresent.RowSpan = 2; tcPresent.Text = "Present/Total"; tr.Cells.Add(tcPresent); Table1.Rows.Add(tr); Table1.Rows.Add(trWeekDay); DataTable dtEmpList = dtFilter.DefaultView.ToTable(true, "Emp_Id"); int empCounter = 0; if (dtEmpList.Rows.Count > 0) { while (empCounter < dtEmpList.Rows.Count) { DataTable dtAttbyEmpId = new DataView(dtFilter, "Emp_Id = '" + dtEmpList.Rows[empCounter][0].ToString() + "'", "Att_Date", DataViewRowState.CurrentRows).ToTable(); DateTime dtFromTemp = InitDtFrom; DateTime dtToTemp = dtTo; int maxshift = 0; while (dtFromTemp < dtToTemp) { dtFromTemp = dtFromTemp.AddDays(1); DataTable dtTempDateRecordEmp = new DataView(dtAttbyEmpId, "Att_Date = '" + dtFromTemp.ToString("dd-MMM-yyyy") + "'", "Att_Date", DataViewRowState.CurrentRows).ToTable(); if (maxshift < dtTempDateRecordEmp.Rows.Count) { maxshift = dtTempDateRecordEmp.Rows.Count; } } TableRow[] trEmp = new TableRow[maxshift]; int[] absent = new int[maxshift]; int[] present = new int[maxshift]; int[] early = new int[maxshift]; int[] late = new int[maxshift]; int[] total = new int[maxshift]; try { present[0] = 0; early[0] = 0; late[0] = 0; total[0] = 0; } catch { } int tempcounter = 0; while (tempcounter < maxshift) { trEmp[tempcounter] = new TableRow(); tempcounter++; } TableCell tcSNOEmp = new TableCell(); tcSNOEmp.Text = (empCounter + 1).ToString(); if (maxshift > 0) { trEmp[0].Cells.Add(tcSNOEmp); TableCell tcNameEmp1 = new TableCell(); tcNameEmp1.Text = dtAttbyEmpId.Rows[1]["Emp_Code"].ToString(); trEmp[0].Cells.Add(tcNameEmp1); TableCell tcNameEmp = new TableCell(); tcNameEmp.Text = dtAttbyEmpId.Rows[0]["Emp_Name"].ToString(); trEmp[0].Cells.Add(tcNameEmp); dtFrom = dtFromBK; } int presentcount = 0; while (dtFrom <= dtTo) { int shiftCounter = 0; DataTable dtTempDateRecordEmp = new DataView(dtAttbyEmpId, "Att_Date = '" + dtFrom.ToString("dd-MMM-yyyy") + "'", "Att_Date", DataViewRowState.CurrentRows).ToTable(); while (shiftCounter < maxshift) { TableCell tcDay = new TableCell(); string attEmp = string.Empty; if (shiftCounter < dtTempDateRecordEmp.Rows.Count) { if ((Convert.ToBoolean(dtTempDateRecordEmp.Rows[shiftCounter]["Is_Week_Off"].ToString()))) { attEmp = attEmp + WeekOff; tcDay.BackColor = System.Drawing.ColorTranslator.FromHtml(hextoint(WeekOffcol).ToString()); } else if ((Convert.ToBoolean(dtTempDateRecordEmp.Rows[shiftCounter]["Is_Holiday"].ToString()))) { attEmp = attEmp + Holiday; tcDay.BackColor = System.Drawing.ColorTranslator.FromHtml(hextoint(Holidaycol).ToString()); } else if (Convert.ToBoolean(dtTempDateRecordEmp.Rows[shiftCounter]["Is_Leave"].ToString())) { attEmp = attEmp + Leave; tcDay.BackColor = System.Drawing.ColorTranslator.FromHtml(hextoint(Leavecol).ToString()); } else if (Convert.ToBoolean(dtTempDateRecordEmp.Rows[shiftCounter]["Is_Absent"].ToString())) { attEmp = attEmp + Absent; tcDay.BackColor = System.Drawing.ColorTranslator.FromHtml(hextoint(Absentcol).ToString()); } else { attEmp = attEmp + Normal; tcDay.BackColor = System.Drawing.ColorTranslator.FromHtml(hextoint(Normalcol).ToString()); presentcount++; } absent[shiftCounter] = absent[shiftCounter] + 1; } else { attEmp = "-"; } tcDay.Text = attEmp; trEmp[shiftCounter].Cells.Add(tcDay); trEmp[shiftCounter].Cells.Add(tcDay); if (dtFrom == dtTo) { TableCell tcabsnt = new TableCell(); tcabsnt.Text = presentcount.ToString() + "/" + totalDays.ToString(); trEmp[shiftCounter].Cells.Add(tcabsnt); } // shiftCounter = shiftCounter + 1; } dtFrom = dtFrom.AddDays(1); } for (int maxcounter = 1; maxcounter <= maxshift; maxcounter++) { if (maxcounter < maxshift) { trEmp[maxcounter].Cells.AddAt(0, new TableCell()); trEmp[maxcounter].Cells.AddAt(0, new TableCell()); trEmp[maxcounter].Cells.AddAt(0, new TableCell()); } Table1.Rows.Add(trEmp[maxcounter - 1]); } empCounter++; } } lblmonthname.Text = "Month " + ": " + ddlMonth.SelectedItem.Text; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_LateReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable4 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 16.66667F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(19F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(667.9999F, 16.66667F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell8, this.xrTableCell10, this.xrTableCell11, this.xrTableCell12 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell5.Font = new System.Drawing.Font("Verdana", 8F); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseFont = false; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell5.Weight = 0.93953195788864219; this.xrTableCell5.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell5_BeforePrint); // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Shift_Name") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 2.2375510098715048; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OnDuty_Time") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell10.Weight = 1.4621368168919577; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.In_Time") }); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 1.0407794195295546; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell12 // this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.LateMin") }); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.Text = "xrTableCell12"; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell12.Weight = 0.99999940898356665; this.xrTableCell12.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell12_BeforePrint); // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 14.99999F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(19F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(667.9999F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell1, this.xrTableCell2, this.xrTableCell4, this.xrTableCell6 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.81705725213459512; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Shift Name"; this.xrTableCell1.Weight = 1.9458707088912264; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "On Duty Time"; this.xrTableCell2.Weight = 1.2715369911197367; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "In Time"; this.xrTableCell4.Weight = 0.90510651734425263; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "Late Hour"; this.xrTableCell6.Weight = 0.86964301330229576; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(391.7918F, 0.9583156F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(19.00001F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(325.7917F, 22.99999F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(19F, 0F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(668F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(3.000006F, 28F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(117.5F, 54F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(450.1771F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(563F, 4.000003F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(3.000006F, 3F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 14.99999F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(19F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(668F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.3645834350585937; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 4.5593200683593746; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable5, this.xrTable4 }); this.GroupFooter1.HeightF = 16.04166F; this.GroupFooter1.Name = "GroupFooter1"; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(19F, 0F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5 }); this.xrTable5.SizeF = new System.Drawing.SizeF(370.6045F, 16.04166F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3, this.xrTableCell20 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell3 // this.xrTableCell3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseFont = false; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "Late Count : "; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.xrTableCell3.Weight = 2.8102122353133421; // // xrTableCell20 // this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.StylePriority.UseFont = false; this.xrTableCell20.StylePriority.UseTextAlignment = false; this.xrTableCell20.Text = "xrTableCell19"; this.xrTableCell20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell20.Weight = 0.89583314138834; this.xrTableCell20.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell20_BeforePrint); // // xrTable4 // this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable4.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(389.6045F, 0F); this.xrTable4.Name = "xrTable4"; this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4 }); this.xrTable4.SizeF = new System.Drawing.SizeF(297.3954F, 16.04166F); this.xrTable4.StylePriority.UseBorders = false; this.xrTable4.StylePriority.UseFont = false; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell9, this.xrTableCell19 }); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1; // // xrTableCell9 // this.xrTableCell9.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseFont = false; this.xrTableCell9.Text = "Late Hours :"; this.xrTableCell9.Weight = 1.2665082630587135; // // xrTableCell19 // this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell19.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.StylePriority.UseFont = false; this.xrTableCell19.StylePriority.UseTextAlignment = false; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell19.Weight = 1.7074463689552706; this.xrTableCell19.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell19_BeforePrint); // // Att_LateReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(100, 53, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); DateTime FromDate1 = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); FromDate1 = FromDate; Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } DataTable dtEmp = dtFilter.DefaultView.ToTable(true, "Emp_Id"); DataTable dtTemp = new DataTable(); DataTable dtSalary = new DataTable(); dtSalary = dtFilter.Clone(); int Total_Days = 0; int Days_In_WorkMin = 0; int Worked_Days = 0; int Week_Off_Days = 0; int Holiday_Days = 0; int Leave_Days = 0; int Absent_Days = 0; int Assigned_Worked_Min = 0; double Basic_Salary = 0; double Basic_Min_Salary = 0; double Normal_OT_Salary = 0; double Week_Off_OT_Salary = 0; double Holiday_OT_Salary = 0; double Absent_Penalty = 0; double Late_Penalty_Min = 0; double Early_Penalty_Min = 0; double Partial_Penalty_Min = 0; int Total_Worked_Min = 0; int Holiday_OT_Min = 0; int Week_Off_OT_Min = 0; int Normal_OT_Min = 0; int Late_Min = 0; int Early_Min = 0; int Partial_Min = 0; double Basic_Work_Salary = 0; double Normal_OT_Work_Salary = 0; double WeekOff_OT_Work_Salary = 0; double Holiday_OT_Work_Salary = 0; double Week_Off_Days_Salary = 0; double Holiday_Days_Salary = 0; double Leave_Days_Salary = 0; double Absent_Day_Penalty = 0; double Late_Min_Penalty = 0; double Early_Min_Penalty = 0; double Parital_Violation_Penalty = 0; bool IsEmpLate = false; bool IsEmpEarly = false; bool IsEmpPartial = false; string LateMethod = string.Empty; string EarlyMethod = string.Empty; string PartialMethod = string.Empty; int LatePenaltyDedMin = 0; int EarlyPenaltyDedMin = 0; int PartialPenaltyDedMin = 0; int PartialMin = 0; int TotalOTMin = 0; double TotalGrossSalary = 0; int j = 0; for (int i = 0; i < dtEmp.Rows.Count; i++) { FromDate = FromDate1; IsEmpLate = false; IsEmpEarly = false; IsEmpPartial = false; LateMethod = string.Empty; EarlyMethod = string.Empty; PartialMethod = string.Empty; LatePenaltyDedMin = 0; EarlyPenaltyDedMin = 0; PartialPenaltyDedMin = 0; TotalOTMin = 0; Assigned_Worked_Min = 0; Basic_Salary = 0; Basic_Min_Salary = 0; Normal_OT_Salary = 0; Week_Off_OT_Salary = 0; Holiday_OT_Salary = 0; Absent_Penalty = 0; Late_Penalty_Min = 0; Early_Penalty_Min = 0; Partial_Penalty_Min = 0; TotalGrossSalary = 0; try { IsEmpEarly = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Field2")); IsEmpLate = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Field1")); IsEmpPartial = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Is_Partial_Enable")); LateMethod = objAppParam.GetApplicationParameterValueByParamName("Is_Late_Penalty_Method", Session["CompId"].ToString()); EarlyMethod = objAppParam.GetApplicationParameterValueByParamName("Is_Early_Penalty_Method", Session["CompId"].ToString()); PartialMethod = objAppParam.GetApplicationParameterValueByParamName("Partial_Penalty_Method", Session["CompId"].ToString()); LatePenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Late_Penalty_Min_Deduct", Session["CompId"].ToString())); EarlyPenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Early_Penalty_Min_Deduct", Session["CompId"].ToString())); PartialPenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Partial_Penalty_Min_Deduct", Session["CompId"].ToString())); Total_Days = ToDate.Subtract(FromDate).Days + 1; Days_In_WorkMin = int.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Assign_Min")); } catch { } try { Basic_Salary = double.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Basic_Salary")); } catch { } int assingmin = 0; try { assingmin = int.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Assign_Min")); } catch { } Basic_Min_Salary = Basic_Salary / (Total_Days * assingmin); if (Basic_Min_Salary.ToString() == "NaN") { Basic_Min_Salary = 0; } Normal_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "Normal", Basic_Min_Salary); Week_Off_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "WeekOff", Basic_Min_Salary); Holiday_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "Holiday", Basic_Min_Salary); Absent_Penalty = OnDayAbsentSalary(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Late_Penalty_Min = OnMinuteLatePenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Early_Penalty_Min = OnMinuteEarlyPenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Partial_Penalty_Min = OnMinuteParialPenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); while (FromDate <= ToDate) { PartialMin = 0; Total_Worked_Min = 0; Holiday_OT_Min = 0; Week_Off_OT_Min = 0; Normal_OT_Min = 0; Late_Min = 0; Early_Min = 0; Partial_Min = 0; Basic_Work_Salary = 0; Normal_OT_Work_Salary = 0; WeekOff_OT_Work_Salary = 0; Holiday_OT_Work_Salary = 0; Week_Off_Days_Salary = 0; Holiday_Days_Salary = 0; Leave_Days_Salary = 0; Absent_Day_Penalty = 0; Late_Min_Penalty = 0; Early_Min_Penalty = 0; Parital_Violation_Penalty = 0; PartialMin = 0; dtTemp = dtFilter.Clone(); dtTemp = new DataView(dtFilter, "Att_Date='" + FromDate.ToString("dd-MMM-yyyy") + "' and Emp_Id='" + dtEmp.Rows[i]["Emp_Id"].ToString() + "' ", "", DataViewRowState.CurrentRows).ToTable(); if (dtTemp.Rows.Count > 0) { for (int k = 0; k < dtTemp.Rows.Count; k++) { dtSalary.ImportRow(dtTemp.Rows[k]); dtSalary.Rows[j]["Field2"] = ""; dtSalary.Rows[j]["Field3"] = ""; dtSalary.Rows[j]["Field4"] = ""; // Late_Min = int.Parse(dtTemp.Rows[k]["LateMin"].ToString()); if (IsEmpLate && LateMethod == "Min") { Late_Min = Late_Min * LatePenaltyDedMin; } Early_Min = int.Parse(dtTemp.Rows[k]["EarlyMin"].ToString()); if (IsEmpEarly && EarlyMethod == "Min") { Early_Min = Early_Min * EarlyPenaltyDedMin; } PartialMin = int.Parse(dtTemp.Rows[k]["Partial_Violation_Min"].ToString()); Total_Worked_Min = int.Parse(dtTemp.Rows[k]["TotalAssign_Min"].ToString()); Days_In_WorkMin = int.Parse(dtTemp.Rows[k]["EffectiveWork_Min"].ToString()); // Days_In_WorkMin = int.Parse(getWorkMinute(Days_In_WorkMin.ToString(),Total_Worked_Min.ToString())); Normal_OT_Min = int.Parse(dtTemp.Rows[k]["OverTime_Min"].ToString()); Week_Off_OT_Min = int.Parse(dtTemp.Rows[k]["Week_Off_Min"].ToString()); Holiday_OT_Min = int.Parse(dtTemp.Rows[k]["Holiday_Min"].ToString()); Late_Min_Penalty = Late_Min * Late_Penalty_Min; Early_Min_Penalty = Early_Penalty_Min * Early_Min; Parital_Violation_Penalty = Partial_Penalty_Min * PartialMin; Absent_Day_Penalty = Absent_Penalty * Total_Worked_Min; Basic_Work_Salary = Basic_Min_Salary * Days_In_WorkMin; Normal_OT_Work_Salary = Normal_OT_Salary * Normal_OT_Min; WeekOff_OT_Work_Salary = Week_Off_OT_Salary * Week_Off_OT_Min; Holiday_OT_Work_Salary = Holiday_OT_Salary * Holiday_OT_Min; double TotalSalary = 0; TotalOTMin += int.Parse(dtTemp.Rows[k]["OverTime_Min"].ToString()); if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Week_Off"].ToString())) { dtSalary.Rows[j]["Field4"] = System.Math.Round(WeekOff_OT_Work_Salary, 2).ToString(); TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["OverTime_Min"] = dtTemp.Rows[k]["Week_Off_Min"]; TotalOTMin += int.Parse(dtTemp.Rows[k]["Week_Off_Min"].ToString()); } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Holiday"].ToString())) { dtSalary.Rows[j]["Field4"] = System.Math.Round(Holiday_OT_Work_Salary, 2).ToString(); TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["OverTime_Min"] = dtTemp.Rows[k]["Holiday_Min"]; TotalOTMin += int.Parse(dtTemp.Rows[k]["Holiday_Min"].ToString()); } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Leave"].ToString())) { TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["Field4"] = "0"; } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Absent"].ToString())) { TotalSalary = Basic_Work_Salary - Absent_Day_Penalty; dtSalary.Rows[j]["Field4"] = "0"; } else if (Days_In_WorkMin != 0) { dtSalary.Rows[j]["Field4"] = System.Math.Round(Normal_OT_Work_Salary, 2).ToString(); } TotalSalary = Basic_Work_Salary - Late_Min_Penalty - Early_Min_Penalty - Parital_Violation_Penalty; dtSalary.Rows[j]["Field3"] = System.Math.Round(TotalSalary, 2).ToString(); dtSalary.Rows[j]["Field2"] = TotalOTMin.ToString(); try { TotalGrossSalary = TotalGrossSalary + TotalSalary + double.Parse(dtSalary.Rows[j]["Field4"].ToString()); } catch { TotalGrossSalary = TotalGrossSalary + TotalSalary; } dtSalary.Rows[j]["Field5"] = System.Math.Round(TotalGrossSalary, 2).ToString(); // j++; } } FromDate = FromDate.AddDays(1); } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Daily Salary Report" + " From " + FromDate1.ToString(objSys.SetDateFormat()) + " To " + ToDate.ToString(objSys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtSalary; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_OverTimeReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTable4 = new DevExpress.XtraReports.UI.XRTable(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 16.66667F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(658F, 16.66667F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell19, this.xrTableCell11, this.xrTableCell9, this.xrTableCell5, this.xrTableCell8 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell19 // this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.Weight = 1.2940813494850054; this.xrTableCell19.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell19_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.In_Time") }); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 1.1138025212906615; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Out_Time") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "xrTableCell9"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell9.Weight = 1.3721185315867972; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Field2") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.Weight = 1.3963244793814174; this.xrTableCell5.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell5_BeforePrint); // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Field3") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.Weight = 1.5036732671749602; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 15.41665F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(9.99999F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(658F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell4, this.xrTableCell6, this.xrTableCell1, this.xrTableCell2 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.91670386411693416; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "In Time"; this.xrTableCell4.Weight = 0.78899742442073029; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "Out Time"; this.xrTableCell6.Weight = 0.97198417215226307; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Over Time Hour"; this.xrTableCell1.Weight = 0.98913048911321011; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Over Time Type"; this.xrTableCell2.Weight = 1.0651750180656499; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(372.7917F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(9.99999F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75.41669F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(9.99999F, 0.4166946F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(657.9999F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(3.50001F, 27F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(102F, 50F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(450.1771F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(553.5F, 2F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(3.50001F, 2F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 14.99999F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(10F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(657.9999F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.26458343505859372; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 4.5593194580078125; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // xrTableCell21 // this.xrTableCell21.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell21.Name = "xrTableCell21"; this.xrTableCell21.Text = "xrTableCell21"; this.xrTableCell21.Weight = 3.049035339355469; this.xrTableCell21.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell21_BeforePrint); // // xrTableCell20 // this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.Text = "Holiday OT Hour :"; this.xrTableCell20.Weight = 1.2426312255859375; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell20, this.xrTableCell21 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell23 // this.xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell23.Name = "xrTableCell23"; this.xrTableCell23.Text = "xrTableCell23"; this.xrTableCell23.Weight = 0.96874984741210934; this.xrTableCell23.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell23_BeforePrint); // // xrTableCell12 // this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.Text = "Week Off OT Hour :"; this.xrTableCell12.Weight = 1.3229167175292969; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell10.Weight = 0.75736877441406247; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "Normal OT Hour :"; this.xrTableCell3.Weight = 1.2426312255859375; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3, this.xrTableCell10, this.xrTableCell12, this.xrTableCell23 }); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1; // // xrTable4 // this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable4.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(9.99999F, 0F); this.xrTable4.Name = "xrTable4"; this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4, this.xrTableRow5 }); this.xrTable4.SizeF = new System.Drawing.SizeF(657.9999F, 39.99999F); this.xrTable4.StylePriority.UseBorders = false; this.xrTable4.StylePriority.UseFont = false; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable4 }); this.GroupFooter1.HeightF = 40.41665F; this.GroupFooter1.Name = "GroupFooter1"; // // Att_OverTimeReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(100, 72, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_ExceptionReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.sp_Set_Employee_Holiday_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Set_Employee_Holiday_ReportTableAdapter(); this.sp_Set_Att_Employee_Leave_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Set_Att_Employee_Leave_ReportTableAdapter(); this.sp_Att_AttendanceLog_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceLog_ReportTableAdapter(); this.sp_Att_AttendanceLog_ReportTableAdapter2 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceLog_ReportTableAdapter(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 14.99999F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(20.09638F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(658.2163F, 14.99999F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell6, this.xrTableCell8, this.xrTableCell9 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Code") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "Leave Name"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell5.Weight = 0.64027476790793081; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.Text = "Total Leave"; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell6.Weight = 2.0197187174333022; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "Paid Leave"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 0.95247117865175412; this.xrTableCell8.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell8_BeforePrint); // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Field1") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "Schedule Type"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell9.Weight = 2.1116674028825733; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 14.99999F; this.GroupHeader1.Name = "GroupHeader1"; this.GroupHeader1.StylePriority.UseTextAlignment = false; this.GroupHeader1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(20.09649F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(658.2162F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell11, this.xrTableCell7, this.xrTableCell1, this.xrTableCell2 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell11 // this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.Text = "ID"; this.xrTableCell11.Weight = 0.61149171220092424; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseTextAlignment = false; this.xrTableCell7.Text = "Name"; this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.xrTableCell7.Weight = 1.9289231730122785; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Event Date"; this.xrTableCell1.Weight = 0.90965369126012507; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.StylePriority.UseTextAlignment = false; this.xrTableCell2.Text = "In/Out Exception"; this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell2.Weight = 2.0167393947290413; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(383.1045F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(20.09649F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 75F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(20.09649F, 0F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(658.2162F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(6.403507F, 27F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(90.9035F, 54F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(470.5053F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(554.2162F, 1.999998F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(100F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(6.403507F, 2F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 14.99999F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(20.09649F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(658.2162F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.3645834350585937; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.13541648864746092; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Code") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.96875007629394538; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.49263153076171884; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.15929840087890612; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 4.46148193359375; // // sp_Set_Employee_Holiday_ReportTableAdapter1 // this.sp_Set_Employee_Holiday_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Set_Att_Employee_Leave_ReportTableAdapter1 // this.sp_Set_Att_Employee_Leave_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Att_AttendanceLog_ReportTableAdapter1 // this.sp_Att_AttendanceLog_ReportTableAdapter1.ClearBeforeFill = true; // // sp_Att_AttendanceLog_ReportTableAdapter2 // this.sp_Att_AttendanceLog_ReportTableAdapter2.ClearBeforeFill = true; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // Att_ExceptionReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2 }); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(76, 72, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "Att_AbsentReport.resx"; this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.attendanceDataSet1 = new AttendanceDataSet(); this.sp_Att_ScheduleDescription_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_ScheduleDescription_ReportTableAdapter(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel(); this.xrCompAddress = new DevExpress.XtraReports.UI.XRLabel(); this.xrTitle = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrCompName = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.sp_Att_AttendanceRegister_ReportTableAdapter1 = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 16.66667F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Verdana", 8F); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(647.0626F, 16.66667F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell19, this.xrTableCell8, this.xrTableCell12, this.xrTableCell10, this.xrTableCell11, this.xrTableCell9 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell19 // this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Att_Date") }); this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.Text = "xrTableCell19"; this.xrTableCell19.Weight = 0.9395317810340722; this.xrTableCell19.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell19_BeforePrint); // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Shift_Name") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 1.5500510512363213; // // xrTableCell12 // this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OnDuty_Time") }); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell12.Weight = 1.0289617205900323; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.OffDuty_Time") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell10.Weight = 1.1562497788476174; this.xrTableCell10.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell10_BeforePrint); // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.In_Time") }); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell11.Weight = 0.82520478134073172; this.xrTableCell11.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell11_BeforePrint); // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Out_Time") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "xrTableCell9"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell9.Weight = 0.97062725190557164; // // TopMargin // this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.GroupHeader1.HeightF = 15.41665F; this.GroupHeader1.Name = "GroupHeader1"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(647.0627F, 14.99999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell1, this.xrTableCell5, this.xrTableCell2, this.xrTableCell4, this.xrTableCell6 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1; // // xrTableCell7 // this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "Date"; this.xrTableCell7.Weight = 0.81705725213459512; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Shift Name"; this.xrTableCell1.Weight = 1.3479910369971919; // // xrTableCell5 // this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "On Duty Time"; this.xrTableCell5.Weight = 0.89482963619939626; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Off Duty Time"; this.xrTableCell2.Weight = 1.0055244001735313; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "In Time"; this.xrTableCell4.Weight = 0.71763349183756242; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "Out Time"; this.xrTableCell6.Weight = 0.84409929257340988; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1 }); this.PageFooter.HeightF = 23.95833F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPageInfo2.Format = "Page{0}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(351.8545F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(295.2082F, 23F); this.xrPageInfo2.StylePriority.UseBorders = false; this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo1 // this.xrPageInfo1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(344.7917F, 23F); this.xrPageInfo1.StylePriority.UseBorders = false; // // attendanceDataSet1 // this.attendanceDataSet1.DataSetName = "AttendanceDataSet"; this.attendanceDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sp_Att_ScheduleDescription_ReportTableAdapter1 // this.sp_Att_ScheduleDescription_ReportTableAdapter1.ClearBeforeFill = true; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPanel1 }); this.ReportHeader.HeightF = 79.16666F; this.ReportHeader.Name = "ReportHeader"; // // xrPanel1 // this.xrPanel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrCompAddress, this.xrTitle, this.xrPictureBox1, this.xrCompName }); this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 4.166664F); this.xrPanel1.Name = "xrPanel1"; this.xrPanel1.SizeF = new System.Drawing.SizeF(647.0626F, 75F); this.xrPanel1.StylePriority.UseBorders = false; // // xrCompAddress // this.xrCompAddress.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompAddress.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompAddress.LocationFloat = new DevExpress.Utils.PointFloat(2F, 28F); this.xrCompAddress.Name = "xrCompAddress"; this.xrCompAddress.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompAddress.SizeF = new System.Drawing.SizeF(353.125F, 22.04167F); this.xrCompAddress.StylePriority.UseBorders = false; this.xrCompAddress.StylePriority.UseFont = false; this.xrCompAddress.Text = "xrCompAddress"; // // xrTitle // this.xrTitle.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTitle.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrTitle.LocationFloat = new DevExpress.Utils.PointFloat(100F, 53F); this.xrTitle.Name = "xrTitle"; this.xrTitle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrTitle.SizeF = new System.Drawing.SizeF(450.1771F, 16F); this.xrTitle.StylePriority.UseBorders = false; this.xrTitle.StylePriority.UseFont = false; this.xrTitle.StylePriority.UseTextAlignment = false; this.xrTitle.Text = "xrTitle"; this.xrTitle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrPictureBox1 // this.xrPictureBox1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(548F, 2F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(97.06268F, 45.04167F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; this.xrPictureBox1.StylePriority.UseBorders = false; // // xrCompName // this.xrCompName.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrCompName.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold); this.xrCompName.LocationFloat = new DevExpress.Utils.PointFloat(2F, 3F); this.xrCompName.Name = "xrCompName"; this.xrCompName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrCompName.SizeF = new System.Drawing.SizeF(353.125F, 23F); this.xrCompName.StylePriority.UseBorders = false; this.xrCompName.StylePriority.UseFont = false; this.xrCompName.Text = "xrCompName"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Emp_Code", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 15.625F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; // // sp_Att_AttendanceRegister_ReportTableAdapter1 // this.sp_Att_AttendanceRegister_ReportTableAdapter1.ClearBeforeFill = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable5 }); this.GroupFooter1.HeightF = 16.04166F; this.GroupFooter1.Name = "GroupFooter1"; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Times New Roman", 8F); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5 }); this.xrTable5.SizeF = new System.Drawing.SizeF(647.0627F, 16.04166F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3, this.xrTableCell20 }); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1; // // xrTableCell3 // this.xrTableCell3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseFont = false; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "Absent Count : "; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.xrTableCell3.Weight = 5.5016664018714039; // // xrTableCell20 // this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.StylePriority.UseFont = false; this.xrTableCell20.StylePriority.UseTextAlignment = false; this.xrTableCell20.Text = "xrTableCell19"; this.xrTableCell20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell20.Weight = 0.96896051031240515; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Verdana", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3 }); this.xrTable3.SizeF = new System.Drawing.SizeF(647.0626F, 14.99999F); this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell13, this.xrTableCell14, this.xrTableCell16, this.xrTableCell17, this.xrTableCell18, this.xrTableCell15 }); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.Text = "ID"; this.xrTableCell13.Weight = 0.38541674098505574; // // xrTableCell14 // this.xrTableCell14.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseFont = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = ":"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell14.Weight = 0.24999996454642004; // // xrTableCell16 // this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Id") }); this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.74999999485807312; // // xrTableCell17 // this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.Text = "Name"; this.xrTableCell17.Weight = 0.52388153149627958; // // xrTableCell18 // this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseFont = false; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = ":"; this.xrTableCell18.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell18.Weight = 0.29471496900340644; // // xrTableCell15 // this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_Att_AttendanceRegister_Report.Emp_Name") }); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.Weight = 4.2666131719120637; // // Att_AbsentReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1, this.PageFooter, this.ReportHeader, this.GroupHeader2, this.GroupFooter1 }); this.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.DataAdapter = this.sp_Att_AttendanceRegister_ReportTableAdapter1; this.DataMember = "sp_Att_AttendanceRegister_Report"; this.DataSource = this.attendanceDataSet1; this.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.Margins = new System.Drawing.Printing.Margins(100, 72, 0, 0); this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.attendanceDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }