I have the following expression in my SSRS report:
= IIf(IsNothing(Fields!Drop_Off_Time.Value), (TimeValue(Fields!Actual_Arrive_Time.Value) - TimeValue(Fields!Pickup_Time.Value)), CInt(0))
The value when Fields!Drop_Off_Time.Value is not null performs the correct calculation. The value however when Fields!Drop_Off_Time.Value is null
consistently returns the value #Error in the field.
Any ideas are welcome.