0 SQL b98ed2ff-7c3c-4f51-9e7e-bc1400676231 DummyDataSource true EmpID System.String ItemCode System.String ItemID System.String Description System.String ThisYearTotal System.Double Position System.Int32 Side System.Int32 ItemHead System.String AmountPerAnnum System.Double ThisMonth System.Double PaidTillDate System.Double Projected System.Double IncomeHead System.String LessExaempted System.Double RowSequence System.Int32 TotalTaxableIncome System.Double PayrollDataSet IncomeTax DummyDataSource true CurrentRate System.String Parameter System.String TaxableIncome System.String IndividualTaxLiability System.String PayrollDataSet IncomeTaxSlab DummyDataSource true DataColumn1 System.String DataColumn2 System.String DataColumn3 System.String PayrollDataSet IncomeTaxOther DummyDataSource true TaxPercent System.Double TaxableIncome System.Double MaxInvestment System.Double PFInvestment System.Double PayrollDataSet TaxRebeatInvestment DummyDataSource true ChallanNo System.String TaxInvestment System.Double PayrollDataSet TaxChallan 2.39865in 1.38733in 1.41402in 1.10552in 1.40787in 0.22396in true true Income Head Black 1pt 2pt 2pt 2pt 2pt true true Paid Till Date Black 1pt 2pt 2pt 2pt 2pt true true This Month Black 1pt 2pt 2pt 2pt 2pt true true Projected Black 1pt 2pt 2pt 2pt 2pt true true Total Taxable Amount Black 1pt 2pt 2pt 2pt 2pt 0.18875in true true =Fields!IncomeHead.Value 2pt 2pt 2pt 2pt true true =Format(Fields!PaidTillDate.Value,"N2") PaidTillDate 5 true true =Format(Fields!ThisMonth.Value,"N2") ThisMonth 4 Black 1pt 2pt 2pt 2pt 2pt true true =Fields!Projected.Value Projected 3 Black 1pt 2pt 2pt 2pt 2pt true true =CDbl(Fields!PaidTillDate.Value + Fields!ThisMonth.Value + Fields!Projected.Value) - CDbl(Fields!LessExaempted.Value) textbox5 Black 1pt 2pt 2pt 2pt 2pt After true Detail Detail_Collection Output true PayrollDataSet_IncomeTax 0.7875in 0.1in 0.41271in 7.71339in 0.83265in 2.95333in 1.42741in 2.5in 0.22916in true true Current Rate textbox6 11 2pt 2pt 2pt 2pt true true Parameter textbox17 10 2pt 2pt 2pt 2pt true true Taxable Income textbox19 9 2pt 2pt 2pt 2pt true true Individual Tax Liability textbox35 8 2pt 2pt 2pt 2pt 0.18875in true true =Fields!CurrentRate.Value CurrentRate 3 2pt 2pt 2pt 2pt true true =Fields!Parameter.Value 2pt 2pt 2pt 2pt true true =Format(Fields!TaxableIncome.Value,"N2") TaxableIncome 1 2pt 2pt 2pt 2pt true true =Format(Fields!IndividualTaxLiability.Value,"N2") IndividualTaxLiability 2pt 2pt 2pt 2pt 0.20958in true true 2pt 2pt 2pt 2pt true true Total: 2pt 2pt 2pt 2pt true true =Format(Sum(Cdbl(Fields!TaxableIncome.Value)),"N2") textbox33 5 2pt 2pt 2pt 2pt true true =Format(Sum(Cdbl(Fields!IndividualTaxLiability.Value)),"N2") textbox38 4 2pt 2pt 2pt 2pt After true Detail Detail_Collection Output true Before true PayrollDataSet_IncomeTaxSlab 1.2375in 0.1in 0.62749in 7.71339in 1 2pt 2pt 2pt 2pt true true =Fields!DataColumn2.Value 2pt 2pt 2pt 2pt true true =Fields!DataColumn3.Value DataColumn3 2pt 2pt 2pt 2pt 0.20833in true true true true true true Detail Detail_Collection Output true Before true PayrollDataSet_IncomeTaxOther 3.9375in 0.1in 0.42708in 7.71339in 2 2pt 2pt 2pt 2pt 4 0.22in true true Investment allowed(a) 2pt 2pt 2pt 2pt 2 true true 2pt 2pt 2pt 2pt true true 0.22in true true 2pt 2pt 2pt 2pt true true =Fields!TaxPercent.Value.ToString() +" % of annual taxable income less employee's contribution to PF" 2pt 2pt 2pt 2pt true true =Fields!TaxableIncome.Value TaxableIncome_1 2pt 2pt 2pt 2pt true true 0.22in true true true true = "Maximum investment allowed" true true =Fields!MaxInvestment.Value MaxInvestment 2pt 2pt 2pt 2pt true true 0.22in true true true true ="Lower one" true true 2pt 2pt 2pt 2pt true true =iif(Fields!TaxableIncome.Value<Fields!MaxInvestment.Value,Fields!TaxableIncome.Value,Fields!MaxInvestment.Value) 0.22in true true PF contribution by Employee(b) 2 true true 2pt 2pt 2pt 2pt true true =Fields!PFInvestment.Value 0.22in true true PF contribution by Company(c) 2 true true 2pt 2pt 2pt 2pt true true =Fields!PFInvestment.Value 0.23in true true Other Investment( d ) 2 true true 2pt 2pt 2pt 2pt true true =Sum(Fields!TaxInvestment.Value, "PayrollDataSet_TaxChallan") 2pt 2pt 2pt 2pt 0.22in true true Other investment to be made by the employee(d=a-b-c) Silver 2pt 2pt 2pt 2pt 3 true true =(iif(Fields!TaxableIncome.Value<Fields!MaxInvestment.Value,Fields!TaxableIncome.Value,Fields!MaxInvestment.Value)-Fields!PFInvestment.Value)-(Fields!PFInvestment.Value)-Sum(Fields!TaxInvestment.Value, "PayrollDataSet_TaxChallan") Silver 2pt 2pt 2pt 2pt After true After true After true After true After true After true After true After true Before true PayrollDataSet_TaxRebeatInvestment 1.9in 0.1in 1.99in 7.71339in 3 1.25601in 0.38101in 2.14897in 1.25601in 0.36017in 2.31124in 0.20833in true true Name 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true =Parameters!EmpName.Value 2pt 2pt 2pt 2pt true true Assessment Year 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true =Parameters!AssesmentYear.Value 2pt 2pt 2pt 2pt 0.21875in true true Employee ID 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true =Parameters!EmpNo.Value 2pt 2pt 2pt 2pt true true Income Year 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true =Parameters!FiscalYear.Value 2pt 2pt 2pt 2pt 0.20833in true true TIN 2pt 2pt 2pt 2pt true true : 2pt 2pt 2pt 2pt true true =Parameters!TINNo.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt PayrollDataSet_IncomeTax 0.12396in 0.1in 0.63541in 7.71341in 4 4.43333in 1.75pt true true =Parameters!CompanyInfo.Value 0.00104in 1.62083in 0.25in 5.95834in 1 2pt 2pt 2pt 2pt External ="file:///" & Parameters!Logo.Value image/jpg FitProportional 0.03854in 0.1in 0.5625in 1.4in 2 true true =Parameters!Phone.Value true true =Parameters!Address.Value textbox18 0.1in 0.25in 2.475in true true ="Page " & Globals!PageNumber & " of " & Globals!TotalPages 4.95in 0.2in 2.85in 1