1.5in 1.1in 1in 0.8in 0.9in 1.7in 0.85in 0.25in true true Description 2pt 2pt 2pt 2pt true true Earnings textbox3 18 2pt 2pt 2pt 2pt true true UnAuthorized 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 Deduction textbox17 15 2pt 2pt 2pt 2pt true true Amount textbox22 14 2pt 2pt 2pt 2pt 0.22in true true =Fields!Description.Value 2pt 2pt 2pt 2pt 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 true true =Format(Fields!DeducAmount.Value,"###,##") DeducAmount 2pt 2pt 2pt 2pt 0.22in true true Total Earnings 2pt 2pt 2pt 2pt 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(IIf(Fields!Arrear.Value Is Nothing, CDec(0), CDbl(Fields!Arrear.Value))) + Fields!Earnings.Value-Cdbl(IIf(Fields!UnAuthLeave.Value Is Nothing, CDec(0), CDbl(Fields!UnAuthLeave.Value)))),"###,##") textbox16 8 2pt 2pt 2pt 2pt true true Total Deduction 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DeducAmount.Value),"###,##") textbox24 6 2pt 2pt 2pt 2pt 0.22in true true Grand Total 2pt 2pt 2pt 2pt true true =Format(Sum((CStr(CDbl(Fields!Earnings.Value) + CDbl(Fields!Arrear.Value) - CDbl(Fields!UnAuthLeave.Value)))-CDbl(Fields!DeducAmount.Value)),"###,##") textbox6 12 2pt 2pt 2pt 2pt 6 After true Detail Detail_Collection Output true Before true Before true PayrollDataSet_OverAllSummary 0.4in 0.1in 0.91in 7.85in true true ="Total Employees: " & Fields!TotalEmp.Value 1.6in 0.15in 2.15in 0.25in 5.8in External ="file:///" & Parameters!Logo.Value image/jpg Fit 0.05in 0.05in 1.225in 2.05in 1 true true =Parameters!Address.Value 1.5in 0in 7.95in 4 1.75pt 0.05in 6.7in 0.2in 1.25in true true ="Print Date & Time: " & Format(Today(), "dd MMM yyyy") textbox18 0.05in 0.1in 0.2in 2.7in 1