1.5249in 0.9in 0.91908in 0.9in 0.9in 1.07719in 1.52407in 0.9in 0.91574in 1.15741in 0.85744in 0.2in true true Salary/Allowance 2pt 2pt 2pt 2pt 2 true true 2pt 2pt 2pt 2pt true true Textbox26 2pt 2pt 2pt 2pt true true Textbox27 2pt 2pt 2pt 2pt true true Textbox28 2pt 2pt 2pt 2pt true true Deductions Textbox31 2pt 2pt 2pt 2pt 2 true true Textbox67 2pt 2pt 2pt 2pt true true Loans Textbox33 2pt 2pt 2pt 2pt 2 0.2in true true Description 2pt 2pt 2pt 2pt 2 true true Earnings textbox3 18 2pt 2pt 2pt 2pt true true Leave Adj. textbox11 2pt 2pt 2pt 2pt true true Arrear textbox4 17 2pt 2pt 2pt 2pt true true Total textbox14 16 2pt 2pt 2pt 2pt true true Description textbox17 15 2pt 2pt 2pt 2pt 2 true true Amount textbox22 14 2pt 2pt 2pt 2pt true true Description Textbox34 2pt 2pt 2pt 2pt true true Amount Textbox39 2pt 2pt 2pt 2pt 0.2in true true =Fields!Description.Value 2pt 2pt 2pt 2pt 2 true true =Format(Fields!Earnings.Value,"###,##") Earnings 4 2pt 2pt 2pt 2pt true true =iif(sum(Fields!UnAuthLeave.Value, "table1")<>0, Fields!UnAuthLeave.Value,"") textbox13 2pt 2pt 2pt 2pt true true =Format(Fields!Arrear.Value,"###,##") Arrear_1 3 2pt 2pt 2pt 2pt true true =Format(iif(Fields!Earnings.Value<>0,((Fields!Earnings.Value + Fields!Arrear.Value) - (Fields!UnAuthLeave.Value)),""),"###,##") textbox15 2 2pt 2pt 2pt 2pt true true =Fields!DeducDescription.Value 2pt 2pt 2pt 2pt 2 true true =Format(Cdbl(Fields!DeducAmount.Value),"###,##") DeducAmount 2pt 2pt 2pt 2pt true true =Fields!LoanName.Value LoanName 2pt 2pt 2pt 2pt true true =Format(CDbl(Fields!LoanAmount.Value),"###,##") LoanAmount 2pt 2pt 2pt 2pt 0.2in true true Total Earnings 2pt 2pt 2pt 2pt 2 true true =Format(Sum(cdbl(Fields!Earnings.Value)),"###,##") textbox9 10 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!UnAuthLeave.Value),"###,##") textbox19 2pt 2pt 2pt 2pt true true =Format(Sum(Cdbl(Fields!Arrear.Value)),"###,##") textbox10 9 2pt 2pt 2pt 2pt true true =Format(Sum(Cdbl(Fields!Arrear.Value) + Fields!Earnings.Value-Cdbl(Fields!UnAuthLeave.Value)),"###,##") textbox16 8 2pt 2pt 2pt 2pt true true Total Deduction 2pt 2pt 2pt 2pt 2 true true =Format(Sum(Fields!DeducAmount.Value),"###,##") textbox24 6 2pt 2pt 2pt 2pt true true Total Loan Textbox36 2pt 2pt 2pt 2pt true true =Format(Sum(CDBL(Fields!LoanAmount.Value)),"###,##") Textbox41 2pt 2pt 2pt 2pt 0.2in true true Grand Total 2pt 2pt 2pt 2pt 2 true true =Format(Sum(Cdbl(Fields!Arrear.Value) + Fields!Earnings.Value-Cdbl(Fields!UnAuthLeave.Value)-CDbl(Fields!DeducAmount.Value)-CDBL(Fields!LoanAmount.Value)),"###,##") textbox6 12 2pt 2pt 2pt 2pt 7 true true Textbox37 2pt 2pt 2pt 2pt true true Textbox42 2pt 2pt 2pt 2pt =IIF(SUM(CDBL(Fields!UnAuthLeave.Value))<>0,true,false) =IIF(SUM(CDBL(Fields!UnAuthLeave.Value))<>0,false,true) =IIF(SUM(CDBL(Fields!Arrear.Value))<>0,false,true) =IIF(SUM(CDBL(Fields!Arrear.Value))<>0,true,false) After After true Detail Detail_Collection Output true Before true Before true PayrollDataSet_OverAllSummary 0.325in 0.05in 1in 11.57583in true true Check Payment Textbox25 1.58084in 0.025in 0.2136in 1.05in 2 2pt 2pt 2pt 2pt true true Net Payment Textbox35 1.79583in 0.025in 0.2in 1.05in 3 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Format(Sum(Cdbl(Fields!Arrear.Value) + Fields!Earnings.Value-Cdbl(Fields!UnAuthLeave.Value)-CDbl(Fields!DeducAmount.Value)-CDBL(Fields!LoanAmount.Value)),"###,##") 2pt 2pt 2pt 2pt true true =Fields!TotalEmp.Value 1.36652in 1.20945in 0.2in 0.62292in 6 true true Total Head Count Textbox32 1.36278in 0.02292in 0.2in 1.05in 7 2pt 2pt 2pt 2pt true true Total Deduction: 2pt 2pt 2pt 2pt true true Total PP : 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DeducAmount.Value)+Sum(CDBL(Fields!LoanAmount.Value)),"###,##") Textbox38 1.3475in 8.72222in 0.2in 1.06756in 10 1pt 2pt 2pt 2pt true true =Format(Sum(Fields!PPAmount.Value, "PayrollDataSet_OverAllSummary"),"###,##") Textbox40 1.57126in 8.72222in 0.2in 1.06756in 11 1pt 2pt 2pt 2pt true true Total SCI : 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!SCIAmount.Value, "PayrollDataSet_OverAllSummary"),"###,##") Textbox40 1.79348in 8.72222in 0.2in 1.06756in 13 1pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt 2.07778in 1.15in 2.0375in 0.25in 5.8in External ="file:///" & Parameters!Logo.Value image/jpg Fit 0.675in 0.05in 0.70417in 1.4875in 1 1.75pt 0.0625in 8.5875in 0.2in 1.25in true true ="Print Date & Time: " & Format(Today(), "dd MMM yyyy") textbox18 0.0625in 0.0125in 0.2in 2.675in 1