expression help

[sds814]

I wanted to multiply a value by 100 if the Field!FieldNameDescription was equal to "ABC" and ReportFieldValue has a value, but I keep on getting #ERROR.

Here is the code:

=IIF(Fields!FieldNameDescription.Value = "ABC" AND Fields!ReportFieldValue <> Nothing, CStr(CInt(Fields!ReportFieldValue.Value * 100)), Fields!ReportFieldValue.Value)

Thanks for the help.

 

[checkai]

What type of data is ReportFieldValue.Value?

 

[sds814]

data type of int.

 

[haroldholt]

Why are you returning two different data types, a string and an int ?

The iif evaluates better if it sees this...
((Fields!FieldNameDescription.Value = "ABC") AND (Fields!ReportFieldValue <> Nothing)), don't ask me why, I just tried a perfectly good set of ORs in some similar code and it would only execute them if each individual part of the expression evaluated to a boolean...

 

[sds814]

The CStr(CInt(Fields!ReportFieldValue.Value * 100)) I found on a post. So thats why I converted it into string. Thanks for recommending the change in the if statement clause.