1.34097in
0.42758in
0.51722in
0.51722in
1.10972in
1.00455in
0.98858in
0.89692in
1.3483in
0.42758in
0.51722in
0.51722in
1.10973in
0.2in
true
true
Earnings
Textbox1
2pt
2pt
2pt
2pt
4
true
true
Amount in BDT
Textbox2
2pt
2pt
2pt
2pt
true
true
Leave Adj.
Textbox18
2pt
2pt
2pt
2pt
true
true
Arrear Amount
Textbox24
2pt
2pt
2pt
2pt
true
true
Total Amount
Textbox30
2pt
2pt
2pt
2pt
true
true
Deductions
Textbox5
2pt
2pt
2pt
2pt
4
true
true
Amount in BDT
Textbox7
2pt
2pt
2pt
2pt
0.2in
true
true
=Fields!Description.Value
Description
2pt
2pt
2pt
2pt
4
true
true
=Format(Fields!Earning.Value,"###,##")
Textbox4
2pt
2pt
2pt
2pt
true
true
=Format(Fields!unAuthLeave.Value ,"###,##")
unAuthLeave
2pt
2pt
2pt
2pt
true
true
=Format(Fields!Arrear.Value,"###,##")
Textbox25
2pt
2pt
2pt
2pt
true
true
=Format(Fields!Earning.Value+Fields!Arrear.Value-Fields!unAuthLeave.Value,"###,##")
Textbox31
2pt
2pt
2pt
2pt
true
true
=Fields!DeducDescription.Value
Textbox6
2pt
2pt
2pt
2pt
4
true
true
=Format(Sum(Fields!DeducAmount.Value),"###,##")
Textbox8
2pt
2pt
2pt
2pt
0.2in
true
true
Total Earnings
Textbox12
2pt
2pt
1pt
1pt
4
true
true
=Format(Sum(Fields!Earning.Value),"###,##")
Textbox13
2pt
2pt
1pt
1pt
true
true
=Format(Sum(Fields!unAuthLeave.Value),"###,##")
Textbox37
2pt
2pt
1pt
1pt
true
true
=Format(Sum(Fields!Arrear.Value),"###,##")
Textbox27
2pt
2pt
1pt
1pt
true
true
=Format(Sum(Fields!Earning.Value)+Sum(Fields!Arrear.Value)-Sum(Fields!unAuthLeave.Value),"###,##")
Textbox33
2pt
2pt
1pt
1pt
true
true
Total Deductions
Textbox14
2pt
2pt
1pt
1pt
4
true
true
=Format(Sum(Fields!DeducAmount.Value),"###,##")
Textbox15
2pt
2pt
1pt
1pt
0.09375in
true
true
Textbox20
2pt
2pt
2pt
2pt
true
true
Textbox29
2pt
2pt
2pt
2pt
true
true
Textbox46
2pt
2pt
2pt
2pt
true
true
Textbox45
2pt
2pt
2pt
2pt
true
true
Textbox21
2pt
2pt
2pt
2pt
true
true
Textbox38
2pt
2pt
2pt
2pt
true
true
Textbox28
2pt
2pt
2pt
2pt
true
true
Textbox34
2pt
2pt
2pt
2pt
true
true
Textbox22
2pt
2pt
2pt
2pt
true
true
Textbox39
2pt
2pt
2pt
2pt
true
true
Textbox52
2pt
2pt
2pt
2pt
true
true
Textbox54
2pt
2pt
2pt
2pt
true
true
Textbox23
2pt
2pt
2pt
2pt
0.19792in
true
true
Textbox16
2pt
2pt
2pt
2pt
3
true
true
Textbox47
2pt
2pt
2pt
2pt
true
true
Net Pay
Textbox17
2pt
2pt
2pt
2pt
4
true
true
=Format(Sum(Fields!Earning.Value)+Sum(Fields!Arrear.Value)-Sum(Fields!unAuthLeave.Value)-Sum(Fields!DeducAmount.Value),"###,##")
Textbox56
2pt
2pt
2pt
2pt
4
true
true
Textbox19
2pt
2pt
2pt
2pt
=IIF(SUM(CDBL(Fields!Arrear.Value))<>0 OR SUM(CDBL(Fields!unAuthLeave.Value))<>0,true,false)
=IIF(SUM(CDBL(Fields!Arrear.Value))<>0,true,false)
=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 OR SUM(CDBL(Fields!unAuthLeave.Value))<>0,false,true)
=IIF(SUM(CDBL(Fields!Arrear.Value))<>0 OR SUM(CDBL(Fields!unAuthLeave.Value))<>0,true,false)
=IIF(SUM(CDBL(Fields!Arrear.Value))<>0,true,false)
=IIF(SUM(CDBL(Fields!unAuthLeave.Value))<>0,true,false)
After
Before
Before
Before
SalaryMonthlysGross
=Fields!EMPLOYEENO.Value
Equal
=Parameters!prmEmployeeNo.Value
0.89167in
10.72281in
true
1.03in
10.72284in
1in
1in
0
System.Data.DataSet
/* Local Connection */
10bb6992-f0df-4966-8fc3-93cc516dee80
PayrollDataSet
/* Local Query */
Name
System.String
EMPLOYEENO
System.String
Grade
System.String
Designation
System.String
Department
System.String
ActualBasic
System.String
PAYMENTMODE
System.String
ACCOUNTNO
System.String
SalaryMonth
System.DateTime
Description
System.String
ITEMGROUP
System.String
CHANGEDAMOUNT
System.Double
Arrear
System.Double
unAuthLeave
System.Double
ItemCode
System.String
Earning
System.Double
DeducDescription
System.String
DeducAmount
System.Double
ItemID
System.String
Status
System.String
IncomTaxAmount
System.Double
RC
System.String
BName
System.String
STaka
System.String
LName
System.String
TaxMonth
System.DateTime
TaxFiscalYearAmount
System.Double
ISFINALIZED
System.String
LoanAmount
System.Double
LoanDescription
System.String
PF
System.Double
Gratuity
System.Double
JoiningDate
System.DateTime
TINNo
System.String
MonthEndDate
System.DateTime
TotalGross
System.String
Division
System.String
Unit
System.String
PayrollDataSet
D:\LOCAL\BAT\BAT_Desktop\BAT_Desktop.root\BAT_Desktop\Payroll.Report\PayrollDataSet\PayrollDataSet.xsd
Payslip
String
true
true
ReportParameter1
Boolean
ReportParameter1
Inch
2f717e13-f550-425e-9b83-9042f9f407ec