0 System.Data.DataSet /* Local Connection */ b8d4dc51-9885-4c8a-9a3e-8f9a3dcb3ff7 System.Data.DataSet /* Local Connection */ eb00a7a9-bc14-432c-8c1f-4772ec7e253f AttendenceDataSet /* Local Query */ EmployeeName System.String IDNo System.String Designation System.String Grade System.String BC System.String AttnDate System.DateTime AttnType System.Int16 OTHour System.Double ReferenceID System.Int32 KPIStatus System.String Line System.String BackColor System.String ForeColor System.String Section System.String Floor System.String Department System.String AttendenceDataSet D:\Local\EchoTex\Echo_Desktop\Payroll.Report\Attendence\AttendenceDataSet\AttendenceDataSet.xsd MonthlyKPIDetail AttendenceDataSet /* Local Query */ ManPower System.Int32 PerAvgOTGreater2 System.Int32 PerSumOTGreater75 System.Int32 PerSumOTGreater100 System.Int32 PerSumOTGreater52 System.Int32 PerOneOTGreater5 System.Int32 AttendenceDataSet D:\Local\EchoTextPR\Echo_Desktop.root\Echo_Desktop\Payroll.Report\Attendence\AttendenceDataSet\AttendenceDataSet.xsd MnthlyKPIDtlSummary true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox55 2pt 2pt 2pt 2pt true true Textbox95 2pt 2pt 2pt 2pt true true Textbox84 2pt 2pt 2pt 2pt true true Textbox56 2pt 2pt 2pt 2pt true true Textbox57 2pt 2pt 2pt 2pt Rotate270 true true Textbox58 2pt 2pt 2pt 2pt true true Textbox59 2pt 2pt 2pt 2pt true true Textbox87 2pt 2pt 2pt 2pt true true S.L No 2pt 2pt 2pt 2pt true true Name 2pt 2pt 2pt 2pt true true IDNo Textbox13 2pt 2pt 2pt 2pt true true Department Textbox96 2pt 2pt 2pt 2pt true true Section Textbox85 2pt 2pt 2pt 2pt true true DESIG. Textbox11 2pt 2pt 2pt 2pt true true Grade Textbox9 2pt 2pt 2pt 2pt Rotate270 true true B / C Textbox7 2pt 2pt 2pt 2pt true true Line Textbox6 2pt 2pt 2pt 2pt true true Floor Textbox89 2pt 2pt 2pt 2pt 0.36458in 0.50958in 0.40625in 0.41667in 0.48958in 0.41667in 0.4375in 0.375in 0.46875in 0.35417in 0.34291in 0.34375in 0.25in 0.22917in 0.22917in 0.27083in 0.3125in 0.21875in 0.25in 0.375in 0.38542in 0.39583in 0.32292in 0.51042in 0.25in true true =Fields!KPIStatus.Value KPIStatus =Fields!BackColor.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true ="" & Floor(Sum(Fields!OTHour.Value)) & ":" &Round((Sum(Fields!OTHour.Value) mod 1)*60,0) 2pt 2pt 2pt 2pt true true =IIF((Sum(iif(Fields!AttnType.Value = 1 or Fields!AttnType.Value = 3 or Fields!AttnType.Value = 7 or Fields!AttnType.Value = 11 or Fields!AttnType.Value = 12,1,0)))>0,Sum(Fields!OTHour.Value)/(Sum(iif(Fields!AttnType.Value = 1 or Fields!AttnType.Value = 3 or Fields!AttnType.Value = 7 or Fields!AttnType.Value = 11 or Fields!AttnType.Value = 12,1,0))),0) 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!OTHour.Value> 2,1,0)) =iif(Sum(iif(Fields!OTHour.Value> 2,1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!OTHour.Value<>3,0,1)) =iif(Sum(iif(Fields!OTHour.Value<>3,0,1))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!OTHour.Value<>4,0,1)) =iif(Sum(iif(Fields!OTHour.Value<>4,0,1))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!OTHour.Value<>5,0,1)) =iif(Sum(iif(Fields!OTHour.Value<>5,0,1))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!OTHour.Value>5,1,0)) =iif(Sum(iif(Fields!OTHour.Value>5,1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!AttnType.Value = 1 or Fields!AttnType.Value = 3 or Fields!AttnType.Value = 7 or Fields!AttnType.Value = 11 or Fields!AttnType.Value = 12,1,0)) =iif(Sum(iif(Fields!AttnType.Value = 1 or Fields!AttnType.Value = 3 or Fields!AttnType.Value = 7 or Fields!AttnType.Value = 11 or Fields!AttnType.Value = 12,1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!AttnType.Value = 5 or Fields!AttnType.Value = 8,1,0)) =IIF(Sum(iif(Fields!AttnType.Value = 5 or Fields!AttnType.Value = 8,1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!AttnType.Value = 2,1,0)) =IIF(Sum(iif(Fields!AttnType.Value = 2,1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="CL",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="CL",1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="SL",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="SL",1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="EL",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="EL",1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="SPL",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="SPL",1,0))>0,"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="COM",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="COM",1,0)),"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="PL",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="PL",1,0)),"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="ML",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="ML",1,0)),"Yellow","White") 2pt 2pt 2pt 2pt true true =Sum(iif(Fields!KPIStatus.Value="LWOP",1,0)) =IIF(Sum(iif(Fields!KPIStatus.Value="LWOP",1,0)),"Yellow","White") 2pt 2pt 2pt 2pt true true =0 White 2pt 2pt 2pt 2pt true true White 2pt 2pt 2pt 2pt true true =0 White 2pt 2pt 2pt 2pt true true White 2pt 2pt 2pt 2pt =Fields!AttnDate.Value =Fields!AttnDate.Value 0.25in true true =Fields!AttnDate.Value AttnDate1 Middle 2pt 2pt 2pt 2pt Horizontal 0.69792in true true =Fields!AttnDate.Value AttnDate Middle 2pt 2pt 2pt 2pt Rotate270 0.25in true true Textbox91 Middle 2pt 2pt 2pt 2pt Rotate270 0.69792in true true Total Working Hour Textbox93 MediumSeaGreen Middle 2pt 2pt 2pt 2pt Rotate270 0.25in true true Textbox61 Middle 2pt 2pt 2pt 2pt Rotate270 0.69792in true true Total Textbox19 MediumSeaGreen Middle 2pt 2pt 2pt 2pt Rotate270 0.25in true true Textbox62 Middle 2pt 2pt 2pt 2pt Rotate270 0.69792in true true AVGE. Textbox21 DarkViolet Middle 2pt 2pt 2pt 2pt Horizontal 0.25in true true Textbox63 Middle 2pt 2pt 2pt 2pt 0.69792in true true #days > 2 Textbox23 Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox64 Middle 2pt 2pt 2pt 2pt 0.69792in true true #days 3 Textbox25 Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox65 Middle 2pt 2pt 2pt 2pt 0.69792in true true #days 4 Textbox27 Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox66 Middle 2pt 2pt 2pt 2pt 0.69792in true true #days 5 Textbox30 Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox67 Middle 2pt 2pt 2pt 2pt 0.69792in true true #days > 5 Textbox33 Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox68 Middle 2pt 2pt 2pt 2pt 0.69792in true true PRESENT Textbox5 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox69 Middle 2pt 2pt 2pt 2pt 0.69792in true true HOLIDAY Textbox10 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox70 Middle 2pt 2pt 2pt 2pt 0.69792in true true ABSENT Textbox3 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox71 Middle 2pt 2pt 2pt 2pt 0.69792in true true C/L Textbox14 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox72 Middle 2pt 2pt 2pt 2pt 0.69792in true true S/L Textbox17 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox73 Middle 2pt 2pt 2pt 2pt 0.69792in true true E/L Textbox20 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox74 Middle 2pt 2pt 2pt 2pt 0.69792in true true SPL Textbox40 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox75 Middle 2pt 2pt 2pt 2pt 0.69792in true true COM Textbox42 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox76 Middle 2pt 2pt 2pt 2pt 0.69792in true true P/L Textbox36 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox77 Middle 2pt 2pt 2pt 2pt 0.69792in true true M/L Textbox38 Lime Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox78 Middle 2pt 2pt 2pt 2pt 0.69792in true true LWOP Textbox44 Lime Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox79 Middle 2pt 2pt 2pt 2pt 0.69792in true true L/OUT Textbox46 Lime Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox80 Middle 2pt 2pt 2pt 2pt 0.69792in true true LO DATE Textbox48 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox81 Middle 2pt 2pt 2pt 2pt 0.69792in true true NEW EMP. Textbox50 Yellow Middle 2pt 2pt 2pt 2pt 0.25in true true Textbox82 Middle 2pt 2pt 2pt 2pt 0.69792in true true REMARKS / NOTE Textbox52 Yellow Middle 2pt 2pt 2pt 2pt =Fields!IDNo.Value =Fields!EmployeeName.Value 0.44917in true true =Runningvalue(Fields!IDNo.Value,countdistinct,"Tablix1") 2pt 2pt 2pt 2pt 0.93042in true true =Fields!EmployeeName.Value 2pt 2pt 2pt 2pt =Fields!IDNo.Value =Fields!IDNo.Value 0.64583in true true =Fields!IDNo.Value IDNo 2pt 2pt 2pt 2pt =Fields!Section.Value =Fields!Section.Value 0.63959in true true =Fields!Department.Value Department 2pt 2pt 2pt 2pt 0.47499in true true =Fields!Section.Value Section 2pt 2pt 2pt 2pt =Fields!Designation.Value =Fields!Designation.Value 0.60167in true true =Fields!Designation.Value Designation 2pt 2pt 2pt 2pt =Fields!Grade.Value =Fields!Grade.Value 0.3125in true true =Fields!Grade.Value Grade 2pt 2pt 2pt 2pt =Fields!BC.Value =Fields!BC.Value 0.52083in true true =Fields!BC.Value BC 2pt 2pt 2pt 2pt =Fields!Line.Value =Fields!Line.Value 0.33334in true true =Fields!Line.Value Line 2pt 2pt 2pt 2pt =Fields!Floor.Value =Fields!Floor.Value 0.375in true true =Fields!Floor.Value Floor 2pt 2pt 2pt 2pt true true MonthlyKPIDetail 0.16021in 1.19792in 13.95876in 1in 0.645in 0.95125in 1.03125in 1in 1in 0.54167in true true Man Power MediumSeaGreen 2pt 2pt 2pt 2pt true true # workers with avg OT over 2 MediumSeaGreen 2pt 2pt 2pt 2pt true true # workers with total OT > 75 MediumSeaGreen 2pt 2pt 2pt 2pt true true # workers with total OT > 100 MediumSeaGreen 2pt 2pt 2pt 2pt true true # workers with at least 1 day OT > 5 MediumSeaGreen 2pt 2pt 2pt 2pt true true # workers with total OT > 52 MediumSeaGreen 2pt 2pt 2pt 2pt 0.25in true true =Fields!ManPower.Value 2pt 2pt 2pt 2pt true true =Fields!PerAvgOTGreater2.Value 2pt 2pt 2pt 2pt true true =Fields!PerSumOTGreater75.Value 2pt 2pt 2pt 2pt true true =Fields!PerSumOTGreater100.Value 2pt 2pt 2pt 2pt true true =Fields!PerOneOTGreater5.Value 2pt 2pt 2pt 2pt true true =Fields!PerSumOTGreater52.Value 2pt 2pt 2pt 2pt After MnthlyKPIDtlSummary 1.4102in 4.07167in 0.79167in 5.6275in 1 2.20187in textbox29 0.28507in 1.55417in 0.45in 10.32657in true true =Parameters!CompanyInfo.Value 0.02118in 1.55417in 0.25in 10.32657in 1 External ="file:///" & Parameters!Logo.Value FitProportional 0.03646in 0.875in 1.5125in 2 0.91146in 1.55417in 0.25in 10.32657in 3 true true ="( From "& Parameters!FromDate.Value + " To "&Parameters!ToDate.Value & " )" 1.20313in 1.55417in 0.25in 10.32657in 4 0.6875in true true true true A: Absent, H: Weekly Holiday, F: Festival Holiday, CL: Casual Leave, SL: Sick Leave, EL: Earned Leave, SPL: Special Leave, COM: Compensatory Leave Textbox60 0.06944in 1.55417in 0.25in 10.32657in 2pt 2pt 2pt 2pt true true PL: Paternity Leave, ML: Maternity Leave, LWOP: Leave Without Pay Textbox60 0.36875in 1.55417in 0.25in 10.32657in 1 2pt 2pt 2pt 2pt 8.5in 25in 0.375in 0.375in