RDLC help with Syntax VB net

Vs 2008
What I have is an appointment book with serviceCost( currency) and confirmed ( boolean)

What I want to be able to do is to sum up all the serviceCost on the rdlc report to get the total. Then subtract the servicecost where it evaluates to False to get the true total. If something evaluates to false, it means that the service was not completed or the customer missed the appointment.

Not sure how to format it directly on the textfield for the RDLC.

Datatype ServiceCost is Currency and DataType for Confirmed is Boolean

So if I have
ServiceCost Confirmed
$45.50 Perm True
$30.00 Color True
$25.50 WaX False

I want to be able to get 75.50 But that is not what is happening.
I thought I could just get the totals where confirmed =true but
so far have not been able to get that without adding it up and then subtracting the servicecost where it evaluates to False.

Here is what I have tried, including custom code
=Code.SumBooleanAmts(Fields!Confirm.Value, Fields!ServiceCost.Value)

( for above i used
Public Dim ServiceCostTotal as Double
Public Function SumBooleanAmts(Byval Confirm as Boolean, Byval ServiceCost as Object) as Object
If Confirm = True then
ServiceCostTotal += ServiceCost
Else
Return 0
End If
Return ServiceCostTotal
End Function )
--------------------------------------------------------------------




'=Sum(Cdbl(Fields!ServiceCost.Value))-(((sum((Cdbl(Fields!ServiceCost.value and Fields!Confirmed.value.tostring = "False"))))))
'=FormatCurrency(Sum(str(Fields!ServiceCost.Value) -(str(Fields!ServiceCost.value and Fields!Confirmed.value=False))))
'=FormatCurrency(Sum(str(Fields!ServiceCost.Value) -(Str(Fields!ServiceCost.value and CBool(Fields!Confirmed.value=False)))))
'=FormatCurrency(Sum(Fields!ServiceCost.Value and Fields!Confirmed.value=True))
'=FormatCurrency(Sum(str(Fields!ServiceCost.Value) -(str(Fields!ServiceCost.value and Fields!Confirmed.value=False))))
'=IIF(Fields!Confirmed.Value = "False",0,0 and Sum(Fields!ServiceCost.value))
'=Sum(IIF(Fields!ServiceCost.value and Fields!Confirmed.Value="False",0,1))
'=sum(CDec(Fields!ServiceCost.Value and Fields!Confirmed.value=False)))
'=FormatCurrency(Sum(fix(Fields!ServiceCost.Value and Fields!Confirmed.value=False)))
'=IIf (Fields!Confirmed.value ,0,1 and sum(Fields!ServiceCost.Value))Sum(Fields!ServiceCost.Value, "shx_DS_appointmentReports_Appointments")
'=FormatCurrency(Sum(str(Fields!ServiceCost.Value) -(str(Fields!ServiceCost.value and Fields!Confirmed.value=False))))
'=FormatCurrency(Sum(CDec(Fields!ServiceCost.Value and Fields!Confirmed.value=False)))
'=Sum(IIF(Fields!Confirmed.Value = "False", 1, 0))
'=Sum(IIF(Fields!ServiceCost.value and Fields!Confirmed.Value,0,0))
'=IIF(Fields!Confirmed.Value = "False", 0, 0 and Sum(Fields!ServiceCost.value))
'=FormatCurrency(Sum(Fields!ServiceCost.Value and Fields!Confirmed.value=False))

I agree with tiggerc that a SELECT statement should be used to return the data you want. Then you can keep it simple. I believe the code below does what you are looking for.

SELECT c.ID, Sum(t.Amount) AS SumOfAmount
FROM Customers c INNER JOIN Transactions t ON c.ID = t.CustID
WHERE (t.Confirmed)=True
GROUP BY c.ID;

Amount - Currency (Double)
Confirmed - Boolean

The expression for the format must be this way for the RDLC report


=FormatCurrency(Sum(str(Fields!ServiceCost.Value) -(str(Fields!ServiceCost.value and Fields!Confirmed.value=False)))

It always starts with the = sign..

I do know how to create an if then condtional statement but this is not what is needed here.