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
Textbox23
2pt
2pt
2pt
2pt
2
true
true
Textbox61
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
textbox1
19
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
Description
5
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
DeducDescription
1
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
textbox8
11
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
textbox20
7
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
textbox5
13
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
="Over All Summary for the month of: " & Format(Fields!Month.Value,"MMMM yyyy")
textbox7
0.025in
0.05in
0.25in
7.85in
1
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
Textbox38
1.57207in
1.19666in
0.2in
1.2868in
4
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)),"###,##")
Textbox40
1.78596in
1.19694in
0.2in
1.2868in
5
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:
Textbox25
1.3475in
7.68367in
0.2in
1.01077in
8
2pt
2pt
2pt
2pt
true
true
Total PP :
Textbox35
1.57126in
7.69756in
0.2in
0.99768in
9
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 :
Textbox35
1.78847in
7.68367in
0.2in
1.01077in
12
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
:
Textbox48
1.36694in
1.09167in
0.2in
0.09in
14
2pt
2pt
2pt
2pt
true
true
:
Textbox48
1.58639in
1.0875in
0.2in
0.09in
15
2pt
2pt
2pt
2pt
true
true
:
Textbox48
1.80251in
1.08694in
0.2in
0.09in
16
2pt
2pt
2pt
2pt
2.07778in
11.62583in
1.57291in
true
true
true
true
=Parameters!CompanyInfo.Value
1.15in
2.0375in
0.25in
5.8in
="file:///" & Parameters!Logo.Value
image/jpg
Fit
0.675in
0.05in
0.70417in
1.4875in
1
1.5in
0.0375in
0in
9.8375in
2
1.75pt
0.3125in
true
true
true
true
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
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
8.27in
11.69in
11in
8.5in
0.8in
0.5in
0.4in
0.29in
0
SQL
94418eac-343a-45e3-bad1-1fb0ac1ec97d
DummyDataSource
/* Local Query */
true
Description
System.String
ItemGroup
System.String
Arrear
System.Double
UnAuthLeave
System.Double
ItemCode
System.String
Earnings
System.Double
DeducDescription
System.String
DeducAmount
System.Double
ItemID
System.String
TotalEmp
System.Int32
Month
System.DateTime
LoanName
System.String
LoanAmount
System.String
SCIAmount
System.Double
PPAmount
System.String
PayrollDataSet
D:\LOCAL\BAT\BAT_Desktop\BAT_Desktop.root\BAT_Desktop\Payroll.Report\PayrollDataSet\PayrollDataSet.xsd
OverAllSummary
String
true
Report_Parameter_1
String
true
Report_Parameter_2
String
true
ReportParameter1
String
true
ReportParameter1
en-US
true
Inch
e9eae8d5-e9cb-400e-9503-faf5bda31813