0 System.Data.DataSet /* Local Connection */ dbea99fb-df95-4af1-98d0-489d824bf5a6 dsEmpLeaveLedger /* Local Query */ EmpNo System.String Name System.String Department System.String JoiningDate System.DateTime CLEN System.Double SLEN System.Double ALEN System.Double CLAV System.Double SLAV System.Double ALAV System.Double CLAdjust System.Double SLAdjust System.Double ALAdjust System.Double LeaveYear System.String Designation System.String SLNo System.Int32 Grade System.Int32 CLBal System.Double SLBal System.Double ALBal System.Double Year System.Int32 dsEmpLeaveLedger D:\Local\Anwar Group\AnwarGroup_Desktop\AnwarGroup_Desktop\Payroll.Report\PayrollDataSet\dsEmpLeaveLedger.xsd EmpDepartmentalLeave 1.74472in 7.69264in 0.21354in true true ID : 2pt 2pt 2pt 2pt true true =First(Fields!EmpNo.Value, "dsEmpLeaveLedger_EmpDepartmentalLeave") 2pt 2pt 2pt 2pt 0.25in true true Name : 2pt 2pt 2pt 2pt true true =First(Fields!Name.Value, "dsEmpLeaveLedger_EmpDepartmentalLeave") 2pt 2pt 2pt 2pt 0.25in true true Designation : 2pt 2pt 2pt 2pt true true =First(Fields!Designation.Value, "dsEmpLeaveLedger_EmpDepartmentalLeave") 2pt 2pt 2pt 2pt 0.25in true true Department : 2pt 2pt 2pt 2pt true true =First(Fields!Department.Value, "dsEmpLeaveLedger_EmpDepartmentalLeave") 2pt 2pt 2pt 2pt 0.25in true true Date of Joining : 2pt 2pt 2pt 2pt true true =Format(First(Fields!JoiningDate.Value, "dsEmpLeaveLedger_EmpDepartmentalLeave"),"dd MMM yyyy") Textbox23 2pt 2pt 2pt 2pt 0.13in 0.11875in 1.21354in 9.43736in 0.46624in 0.86625in 0.42167in 0.38958in 0.43959in 0.44792in 0.45833in 0.39583in 0.375in 0.48333in 0.52084in 0.40625in 0.53126in 0.48749in 0.48333in 0.50626in 0.48958in 0.69568in 0.57292in 0.25in true true Sl. No. Textbox24 2pt 2pt 2pt 2pt true true Year Textbox26 2pt 2pt 2pt 2pt true true Leave Entitlement Textbox28 2pt 2pt 2pt 2pt 3 true true Leave Availed Textbox36 2pt 2pt 2pt 2pt 4 true true Adj. For Late Attn. Textbox44 2pt 2pt 2pt 2pt 3 true true Balance Textbox50 2pt 2pt 2pt 2pt 3 true true Total Textbox56 2pt 2pt 2pt 2pt 4 0.25in true true Textbox64 2pt 2pt 2pt 2pt true true Textbox65 2pt 2pt 2pt 2pt true true =Parameters!CL.Value Textbox66 2pt 2pt 2pt 2pt true true =Parameters!ML.Value Textbox67 2pt 2pt 2pt 2pt true true =Parameters!AL.Value Textbox68 2pt 2pt 2pt 2pt true true =Parameters!CL.Value Textbox69 2pt 2pt 2pt 2pt true true =Parameters!ML.Value Textbox70 2pt 2pt 2pt 2pt true true =Parameters!AL.Value Textbox71 2pt 2pt 2pt 2pt true true Textbox72 2pt 2pt 2pt 2pt true true =Parameters!CL.Value Textbox73 2pt 2pt 2pt 2pt true true =Parameters!ML.Value Textbox74 2pt 2pt 2pt 2pt true true =Parameters!AL.Value Textbox75 2pt 2pt 2pt 2pt true true =Parameters!CL.Value Textbox76 2pt 2pt 2pt 2pt true true =Parameters!ML.Value Textbox77 2pt 2pt 2pt 2pt true true =Parameters!AL.Value Textbox78 2pt 2pt 2pt 2pt true true Entitled Textbox79 2pt 2pt 2pt 2pt true true Availed Textbox80 2pt 2pt 2pt 2pt true true Late Adj. Textbox81 2pt 2pt 2pt 2pt true true Balance Textbox82 2pt 2pt 2pt 2pt 0.25in true true =RunningValue(Fields!Year.Value,countdistinct,"Tablix2") Textbox25 2pt 2pt 2pt 2pt true true =Fields!Year.Value Year 2pt 2pt 2pt 2pt true true =Fields!CLEN.Value CLEN 2pt 2pt 2pt 2pt true true =Fields!SLEN.Value SLEN 2pt 2pt 2pt 2pt true true =Fields!ALEN.Value ALEN 2pt 2pt 2pt 2pt true true =Fields!CLAV.Value CLAV 2pt 2pt 2pt 2pt true true =Fields!SLAV.Value SLAV 2pt 2pt 2pt 2pt true true =Fields!ALAV.Value ALAV 2pt 2pt 2pt 2pt true true Textbox43 2pt 2pt 2pt 2pt true true =Fields!CLAdjust.Value CLAdjust 2pt 2pt 2pt 2pt true true =Fields!SLAdjust.Value SLAdjust 2pt 2pt 2pt 2pt true true =Fields!ALAdjust.Value ALAdjust 2pt 2pt 2pt 2pt true true =Fields!CLBal.Value CLBal 2pt 2pt 2pt 2pt true true =Fields!SLBal.Value SLBal 2pt 2pt 2pt 2pt true true =Fields!ALBal.Value ALBal 2pt 2pt 2pt 2pt true true =Sum(Fields!CLEN.Value+Fields!SLEN.Value+Fields!ALEN.Value) Textbox57 2pt 2pt 2pt 2pt true true =sum(Fields!CLAV.Value+Fields!SLAV.Value+Fields!ALAV.Value) Textbox59 2pt 2pt 2pt 2pt true true =sum(Fields!CLAdjust.Value+Fields!SLAdjust.Value+Fields!ALAdjust.Value) Textbox61 2pt 2pt 2pt 2pt true true =sum(Fields!CLEN.Value+Fields!SLEN.Value+Fields!ALEN.Value)-(sum(Fields!CLAV.Value+Fields!SLAV.Value+Fields!ALAV.Value)+sum(Fields!CLAdjust.Value+Fields!SLAdjust.Value+Fields!ALAdjust.Value)) Textbox63 2pt 2pt 2pt 2pt After After dsEmpLeaveLedger_EmpDepartmentalLeave 1.505in 0.11875in 0.75in 9.43735in 1 2.30208in 0.05in 2.21875in 0.25in 4.6in 1 true true =Parameters!Address.Value true true =Parameters!Phone.Value true true ="Employee Leave History" textbox5 1.01458in 3.10834in 0.25in 3.45625in 4 0.35417in true true true true ="Print Date : " & Format(Today(), "dd MMM yyyy") textbox18 0.15in 0.00572in 0.2in 1.70104in true true ="Page " & Globals!PageNumber & " of " & Globals!TotalPages 0.15in 8.28177in 0.2in 1.4in 1 8.27in 11.69in 0.1in 0.04in 0.05in 0.05in