SSRS error when evaluating for nulls

[jpeters01]

This formula works unless both the DOSESTRENGTH and DOSE_AMOUNT fields are empty and then it returns #Error. The error occurred after we added the statement to remove the trailing decimals but I don't know how to correct it...any ideas?

=IIF (IsNothing(Fields!DOSESTRENGTH.Value),
IIF (IsNothing(Fields!DOSE_AMOUNT.Value) OR LEN(CStr(Fields!DOSE_AMOUNT.Value)) = 0 OR CStr(Fields!DOSE_AMOUNT.Value) = "",
"",
IIF (CStr(Fields!DOSE_AMOUNT.Value) LIKE "*.*0",
Mid(Cstr(Fields!DOSE_AMOUNT.Value), 1, LEN(Cstr(Fields!DOSE_AMOUNT.Value))-1) & "-" & CStr(Fields!DOSE_UNIT_DESC.Value),
CStr(Fields!DOSE_AMOUNT.Value) & "-" & CStr(Fields!DOSE_UNIT_DESC.Value))),
Fields!DOSESTRENGTH.Value)

 

[DaveInIowa]

Try changing your 'OR' keywords to their short-circuit equivalent 'OrElse'.

 

[jpeters01]

Dave...thanks we will give this a try.