Segoe UI
0
ODBC
Dsn=test
true
Integrated
81645f17-797d-4d90-b3bd-e2848d22ab2c
DataSource1
select Company, File_No, Claim_No, File_Year, Deductible_Amount, SUM(Net_Paid) As Sum_Net_Paid, SUM(Total_Discount) As Sum_Total_Discount
from [Sheet1$]
GROUP BY Company, File_No, Claim_No, File_Year, Deductible_Amount
Company
System.String
File_No
System.String
Claim_No
System.String
File_Year
System.String
Deductible_Amount
System.Double
Sum_Net_Paid
System.Double
Sum_Total_Discount
System.Double
true
true
Title
ReportTitle
0.5in
5.5in
2pt
2pt
2pt
2pt
1in
1in
1in
1in
1.5in
1in
1in
1in
0.25in
true
true
Company
Textbox1
2pt
2pt
2pt
2pt
true
true
File No
Textbox3
2pt
2pt
2pt
2pt
true
true
Claim No
Textbox5
2pt
2pt
2pt
2pt
true
true
File Year
Textbox7
2pt
2pt
2pt
2pt
true
true
Claim Deductible Amt
Textbox13
2pt
2pt
2pt
2pt
true
true
Net Paid
Textbox9
2pt
2pt
2pt
2pt
true
true
Total Discount
Textbox11
2pt
2pt
2pt
2pt
true
true
My Calculation
Textbox15
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Company.Value
Company
2pt
2pt
2pt
2pt
true
true
=Fields!File_No.Value
File_No
2pt
2pt
2pt
2pt
true
true
=Fields!Claim_No.Value
Claim_No
2pt
2pt
2pt
2pt
true
true
=Fields!File_Year.Value
File_Year
2pt
2pt
2pt
2pt
true
true
=Fields!Deductible_Amount.Value
Deductible_Amount
2pt
2pt
2pt
2pt
true
true
=Fields!Sum_Net_Paid.Value
Net_Paid
2pt
2pt
2pt
2pt
true
true
=Fields!Sum_Total_Discount.Value
Total_Discount
2pt
2pt
2pt
2pt
true
true
=IIf(
IIf( (Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)>Fields!Sum_Net_Paid.Value,
Fields!Sum_Net_Paid.Value,
(Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)
)
<=0, 0,
IIf( (Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)>Fields!Sum_Net_Paid.Value,
Fields!Sum_Net_Paid.Value,
(Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)
)
)
2pt
2pt
2pt
2pt
0.25in
true
true
Totals
Textbox2
2pt
2pt
2pt
2pt
true
true
Textbox4
2pt
2pt
2pt
2pt
true
true
Textbox6
2pt
2pt
2pt
2pt
true
true
Textbox8
2pt
2pt
2pt
2pt
true
true
Textbox10
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Sum_Net_Paid.Value)
Textbox12
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Sum_Total_Discount.Value)
Textbox14
2pt
2pt
2pt
2pt
true
true
=Sum( IIf(
IIf( (Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)>Fields!Sum_Net_Paid.Value,
Fields!Sum_Net_Paid.Value,
(Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)
)
<=0, 0,
IIf( (Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)>Fields!Sum_Net_Paid.Value,
Fields!Sum_Net_Paid.Value,
(Fields!Deductible_Amount.Value-Fields!Sum_Total_Discount.Value)
)
)
)
Textbox17
2pt
2pt
2pt
2pt
After
Before
DataSet1
0.51389in
0.75in
8.5in
1
1.51958in
10in
0.45in
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
0.2in
4in
0.25in
2in
2pt
2pt
2pt
2pt
1in
1in
1in
1in
4
2
Inch
208697cd-d8b8-4b2b-95f3-6bcc3c23ee62