0
SQL
6d5896ad-d11c-4350-91e2-682fdf68037d
DummyDataSource
/* Local Query */
true
Name
System.String
IDNo
System.String
Designation
System.String
Department
System.String
Section
System.String
DateOfJoining
System.String
LengthOfService
System.String
TotalLeavePeriod
System.String
DateOfLeaveApporval
System.String
LeaveDaysPayableUnderThisBill
System.String
Particulars
System.String
Before3Month
System.String
Before2Month
System.String
Before1Month
System.String
Total
System.String
DailyAverageEarning
System.String
MaternityStatus
System.String
NetAmountPayable
System.String
ToDate
System.String
FromDate
System.String
PaymentDate
System.String
NumberOfDays
System.String
PaymentAmount
System.String
TaxAmount
System.String
MaternityBenifit
System.String
dsEmpLeaveLedger
D:\SVN\SanofiNew\HRM.Report\PayrollDataSet\dsEmpLeaveLedger.xsd
MaternityLeave
DummyDataSource
/* Local Query */
true
Status
System.String
PaymentDate
System.String
PaymentDays
System.String
Amount
System.String
dsEmpLeaveLedger
D:\SVN\SanofiNew\HRM.Report\PayrollDataSet\dsEmpLeaveLedger.xsd
MaternityStatusDetail
true
true
=First(Fields!DailyAverageEarning.Value, "dsEmpLeaveLedger_MaternityLeave")
3.36611in
1.949in
0.2in
1.9692in
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!MaternityStatus.Value, "dsEmpLeaveLedger_MaternityLeave")
2.3375in
3.92077in
0.22in
3.82074in
1
2pt
2pt
2pt
2pt
true
true
Payment Status
2.3375in
0.09719in
0.22in
3.82101in
2
Black
1pt
Black
1pt
2pt
2pt
2pt
2pt
true
true
Leave days payable under this bill
2.1425in
0.09719in
0.22in
3.82101in
3
Black
1pt
2pt
2pt
2pt
2pt
true
true
="Date of leave approval"
1.9225in
0.09719in
0.22in
3.82101in
4
Black
1pt
2pt
2pt
2pt
2pt
true
true
Total leave period
1.7025in
0.09719in
0.22in
3.82101in
5
Black
1pt
2pt
2pt
2pt
2pt
true
true
Length of Service
1.4825in
0.09719in
0.22in
3.82101in
6
Black
1pt
2pt
2pt
2pt
2pt
true
true
Date of joining
1.2625in
0.09719in
0.22in
3.82101in
7
Black
1pt
2pt
2pt
2pt
2pt
true
true
Name
0.3875in
0.09719in
0.22in
3.82101in
8
Black
1pt
Black
1pt
2pt
2pt
2pt
2pt
true
true
Department
1.0475in
0.09719in
0.22in
3.82101in
9
Black
1pt
2pt
2pt
2pt
2pt
true
true
Designation
0.8275in
0.09719in
0.22in
3.82101in
10
Black
1pt
2pt
2pt
2pt
2pt
true
true
ID No.
textbox1
0.6075in
0.09719in
0.22in
3.82101in
11
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!LeaveDaysPayableUnderThisBill.Value, "dsEmpLeaveLedger_MaternityLeave")
2.1425in
3.92077in
0.22in
3.82074in
12
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!DateOfLeaveApporval.Value, "dsEmpLeaveLedger_MaternityLeave")
1.9225in
3.92077in
0.22in
3.82074in
13
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!LengthOfService.Value, "dsEmpLeaveLedger_MaternityLeave")
1.4825in
3.92077in
0.22in
3.82074in
14
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!DateOfJoining.Value, "dsEmpLeaveLedger_MaternityLeave")
1.2625in
3.92077in
0.22in
3.82074in
15
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!Name.Value, "dsEmpLeaveLedger_MaternityLeave")
0.3875in
3.92077in
0.22in
3.82074in
16
Black
1pt
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!Department.Value, "dsEmpLeaveLedger_MaternityLeave")
1.0475in
3.92077in
0.22in
3.82074in
17
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!Designation.Value, "dsEmpLeaveLedger_MaternityLeave")
0.8275in
3.92077in
0.22in
3.82074in
18
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!IDNo.Value, "dsEmpLeaveLedger_MaternityLeave")
0.6075in
3.92077in
0.22in
3.82074in
19
Black
1pt
2pt
2pt
2pt
2pt
true
true
=": "+First(Fields!FromDate.Value, "dsEmpLeaveLedger_MaternityLeave") +" To " + First(Fields!ToDate.Value, "dsEmpLeaveLedger_MaternityLeave")+ " " + First(Fields!TotalLeavePeriod.Value, "dsEmpLeaveLedger_MaternityLeave")+" Days"
1.7025in
3.92077in
0.22in
3.82074in
20
Black
1pt
2pt
2pt
2pt
2pt
true
true
Earning details of preceding 3 (three) months:
textbox15
2.7625in
0.09719in
0.25in
4.975in
21
true
true
Daily Average Earning =
textbox23
3.36611in
0.08469in
0.2in
1.86431in
22
2pt
2pt
2pt
2pt
3.11875in
4.53807in
0.22in
true
true
="Maternity Benefit : Daily Average Earning * "+First(Fields!TotalLeavePeriod.Value, "dsEmpLeaveLedger_MaternityLeave")
textbox49
2pt
2pt
2pt
2pt
true
true
="TK "+First(Fields!MaternityBenifit.Value, "dsEmpLeaveLedger_MaternityLeave")
MaternityBenifit
2pt
2pt
2pt
2pt
0.25in
true
true
Less : Income Tax
textbox20
2pt
2pt
2pt
2pt
true
true
="TK "+First(Fields!TaxAmount.Value, "dsEmpLeaveLedger_MaternityLeave")
TaxAmount
2pt
2pt
2pt
2pt
0.22in
true
true
Total Payable maternity benefit(After Tax)
textbox40
true
true
="i.e TK "+ First(Fields!NetAmountPayable.Value, "dsEmpLeaveLedger_MaternityLeave")
textbox45
0.22in
true
true
=Fields!Status.Value
PaymentDate
true
true
="TK "+Fields!Amount.Value
Amount
After
true
After
true
After
true
Detail
Detail_Collection
Output
true
dsEmpLeaveLedger_MaternityStatusDetail
3.7625in
0.08469in
0.91in
7.65682in
23
2.57in
1.26858in
1.26858in
1.26858in
1.26858in
0.22167in
true
true
=Fields!Particulars.Value
Particulars
2pt
2pt
2pt
2pt
true
true
=Fields!Before3Month.Value
Before3Month
2pt
2pt
2pt
2pt
true
true
=Fields!Before2Month.Value
Before2Month
2pt
2pt
2pt
2pt
true
true
=Fields!Before1Month.Value
Before1Month
2pt
2pt
2pt
2pt
true
true
=Fields!Total.Value
Total
2pt
2pt
2pt
2pt
Detail
Detail_Collection
Output
true
dsEmpLeaveLedger_MaternityLeave
3.075in
0.09719in
0.22167in
7.64432in
24
8pt
true
true
="Maternity Benefit"
0.05in
0.09719in
0.28in
7.64088in
25
4.6725in
7.83188in
1.07681in
true
true
true
true
=Parameters!CompanyInfo.Value
2.1in
0.25in
5.64151in
="file:///" & Parameters!Logo.Value
image/bmp
Fit
0.09719in
0.95in
1.95281in
1
true
true
=Parameters!Phone.Value
textbox21
0.45in
2.1in
0.2in
5.64151in
2
true
true
=Parameters!Address.Value
textbox29
0.25in
2.1in
0.2in
5.64151in
3
1.04402in
0.09719in
0in
7.64432in
4
1.75pt
0.96884in
true
true
true
true
Prepared By
textbox16
0.05in
0.09719in
0.25in
1.6625in
2pt
2pt
2pt
2pt
true
true
Approved By
textbox18
0.05in
3.37219in
0.25in
1.5125in
1
2pt
2pt
2pt
2pt
true
true
Approved By
textbox19
0.05in
6.32219in
0.25in
1.41588in
2
2pt
2pt
2pt
2pt
true
true
Hridoy Chowdhury
textbox6
0.3in
0.09719in
0.2in
1.65in
3
true
true
Md. Nurul Islam
textbox22
0.3in
3.37219in
0.2in
1.5in
4
true
true
Mohammad Abdur Rashid
textbox29
0.3in
6.32219in
0.2in
1.40682in
5
true
true
Senior Executive
textbox37
0.5in
0.09719in
0.2in
1.65in
6
true
true
Country HR Manager
textbox41
0.5in
3.37219in
0.2in
1.5in
7
true
true
Country Manager
textbox42
0.5in
6.32219in
0.2in
1.40682in
8
true
true
ID No: D1263
textbox43
0.72778in
0.09719in
0.20972in
1.65in
9
true
true
ID No: D1265
textbox46
0.72778in
3.37219in
0.20972in
1.5in
10
true
true
ID No: D4106
textbox47
0.72778in
6.32219in
0.20972in
1.40682in
11
11.69in
8.27in
11in
8.5in
0.21906in
0.21906in
0.4in
0.4in
String
true
true
Report_Parameter_0
String
true
true
Report_Parameter_1
String
true
true
Report_Parameter_2
String
true
true
Report_Parameter_3
String
true
true
Report_Parameter_4
2
3
0
0
SearchCriteria
1
0
CompanyInfo
0
1
Logo
1
1
Address
0
2
Phone
en-US
true
Inch
1754ea71-753b-4a43-9abd-b68c05691711