0 System.Data.DataSet /* Local Connection */ 55641b0c-6cc2-4f8c-99c9-a7988b7e8b45 AttendenceDataSet /* Local Query */ Date System.String InTime System.String OutTime System.String LateBy System.String OTHr System.String Status System.String Remarks System.String Shift System.String IsManualEntry System.Boolean Tiffin System.Int32 Lunch System.Int32 ExtraAllowance System.Int32 EmployeeNo System.String Month System.String NightShiftAllowance System.Double SpecialAllowance System.Double Day System.String AttendenceDataSet C:\CEL SOURCE\EchoTex\Payroll.Report\Attendence\AttendenceDataSet\AttendenceDataSet.xsd EmpDailyAttn 0.5915in 0.37939in 0.55724in 0.5882in 0.41064in 0.45in 0.42in 0.50178in 0.52063in 0.45724in 0.434in 0.5in 0.50516in 1.13in 0.22in true true Date textbox9 Gainsboro 2pt 2pt 2pt 2pt true true Day Textbox6 Gainsboro 2pt 2pt 2pt 2pt true true In Time textbox21 Gainsboro 2pt 2pt 2pt 2pt true true Out Time textbox19 Gainsboro 2pt 2pt 2pt 2pt true true Tiffin Textbox22 Gainsboro 2pt 2pt 2pt 2pt true true Lunch Textbox55 Gainsboro 2pt 2pt 2pt 2pt true true Extra Textbox27 Gainsboro 2pt 2pt 2pt 2pt true true Late By Gainsboro 2pt 2pt 2pt 2pt true true OT Hr. Gainsboro 2pt 2pt 2pt 2pt true true Status Gainsboro 2pt 2pt 2pt 2pt true true Shift textbox10 Gainsboro 2pt 2pt 2pt 2pt true true Night Shift Allowance Textbox1 Gainsboro 2pt 2pt 2pt 2pt true true Special Allowance Textbox5 Gainsboro 2pt 2pt 2pt 2pt true true Remarks textbox11 Gainsboro 2pt 2pt 2pt 2pt 0.2in true true =Fields!Date.Value Date 2pt 2pt 2pt 2pt true true =Fields!Day.Value Day1 2pt 2pt 2pt 2pt true true =Fields!InTime.Value InTime 2pt 2pt 2pt 2pt true true =Fields!OutTime.Value OutTime 2pt 2pt 2pt 2pt true true =Fields!Tiffin.Value Tiffin 2pt 2pt 2pt 2pt true true =Fields!Lunch.Value Lunch 2pt 2pt 2pt 2pt true true =Fields!ExtraAllowance.Value ExtraAllowance 2pt 2pt 2pt 2pt true true =Fields!LateBy.Value 2pt 2pt 2pt 2pt true true =Fields!OTHr.Value 2pt 2pt 2pt 2pt true true =Fields!Status.Value 2pt 2pt 2pt 2pt true true =Fields!Shift.Value Shift 2pt 2pt 2pt 2pt true true =Fields!NightShiftAllowance.Value NightShiftAllowance 2pt 2pt 2pt 2pt true true =Fields!SpecialAllowance.Value SpecialAllowance 2pt 2pt 2pt 2pt true true =Fields!Remarks.Value 2pt 2pt 2pt 2pt 0.22in true true ="Present Days: " & sum(iif(Fields!Status.Value="P" OR Fields!Status.Value="E" OR Fields!Status.Value="L",1,0)) Gainsboro 2pt 2pt 2pt 2pt true true Gainsboro 2pt 2pt 2pt 2pt true true ="Absent Days: "&sum(cint(iif(Fields!Status.Value="A",1,0))) Gainsboro 2pt 2pt 2pt 2pt 2 true true ="Total Tiffin: " Gainsboro 2pt 2pt 2pt 2pt true true ="Total Lunch: " Gainsboro 2pt 2pt 2pt 2pt true true ="Total Extra: " Gainsboro 2pt 2pt 2pt 2pt true true ="Weekly Holidays: "&sum(cint(iif(Fields!Status.Value="W",1,0))) Gainsboro 2pt 2pt 2pt 2pt 2 true true ="Festival Holidays: "&sum(cint(iif(Fields!Status.Value="H",1,0))) textbox50 Gainsboro 2pt 2pt 2pt 2pt 2 true true ="Total Night Shift Allowance" Textbox3 Gainsboro 2pt 2pt 2pt 2pt true true ="Total Special Allowance" Textbox7 Gainsboro 2pt 2pt 2pt 2pt true true ="Total Late Hour: "&Parameters!TotalLateHour.Value Gainsboro 2pt 2pt 2pt 2pt 0.22in true true ="Late Days: "&sum(cint(iif(Fields!Status.Value="L",1,0))) Gainsboro 2pt 2pt 2pt 2pt true true Gainsboro 2pt 2pt 2pt 2pt true true ="Leave Days: "&sum(cint(iif(Fields!Status.Value="Lv",1,0))) Gainsboro 2pt 2pt 2pt 2pt 2 true true =SUM(Fields!Tiffin.Value) Textbox54 Gainsboro 2pt 2pt 2pt 2pt true true =SUM(Fields!Lunch.Value) Textbox59 Gainsboro 2pt 2pt 2pt 2pt true true =Sum(Fields!ExtraAllowance.Value) Textbox58 Gainsboro 2pt 2pt 2pt 2pt true true ="OSD Days: "&sum(cint(iif(Fields!Status.Value="OD",1,0))) Gainsboro 2pt 2pt 2pt 2pt 2 true true ="Half Days: " & sum(iif(Fields!Status.Value="HD",1,0)) textbox51 Gainsboro 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!NightShiftAllowance.Value) Textbox4 Gainsboro 2pt 2pt 2pt 2pt true true =Sum(Fields!SpecialAllowance.Value) Textbox8 Gainsboro 2pt 2pt 2pt 2pt true true ="Total OTHour: "&Parameters!TotalOT.Value Gainsboro 2pt 2pt 2pt 2pt After true true Detail Detail_Collection Output true Before true Before true AttendenceDataSet_EmpDailyAttn =Fields!EmployeeNo.Value Equal =Parameters!EmployeeNo.Value =Fields!Month.Value Equal =Parameters!Month.Value 0.86in 7.44578in 0.86in