Getting errors with this expression

Question

Getting errors with this expression

PhillipK 121

I wrote this expression but not sure why it is not working.
IIF(IsNothing(Fields!BRIDGE_TYP_WK.Value), " " & "Let With: " & Fields!BRIDGE_TYP_WK.Value))

or

=IF(IsNothing(Fields!BRIDGE_TYP_WK.Value), " " || "Let With: " || Fields!BRIDGE_TYP_WK.Value))

Accepted answer

1 additional answer

Your answer

Answer 1

Anonymous

Hi @PhillipK
It looks like you are using the IIF function incorrectly. What IIF does is return one of two objects based on the evaluation of the expression, and your expression only has one object.
For example:
=IIF(IsNothing(Fields!LocInv.Value), "NONE", "Let With: " & Fields!LocInv.Value)

For more details, you can refer to Decision Functions in this link: expression-examples-report-builder-and-ssrs.
Best regards,
Aniya

PhillipK 121 Reputation points

2022-12-01T15:48:39.49+00:00

The original one is this on Crystal Rpt
if isnull({Bridge_US1.BRIDGE_TYP_WK}) then ''
else ('Let With: ' & {Bridge_US1.BRIDGE_TYP_WK})

I tried this one now based on what you mentioned. If the value in Fields!BRIDGE_TYP_WK.Value) is nothing or null then concat the Let With: XXXXXXXXXXXXXXXXXX(bridge Value data....

=IIF(IsNothing(Fields!BRIDGE_TYP_WK.Value) OR Fields!BRIDGE_TYP_WK.Value = " ", & "Let With: " & Fields!BRIDGE_TYP_WK.Value,""))
PhillipK 121 Reputation points

2022-12-01T15:49:40.163+00:00

I think some comma or syntax missing. I have similarly others and they work fine.
Anonymous

2022-12-02T01:54:48.487+00:00
Hi @PhillipK
According to your information, you want to show empty when the value of the field is empty, and display Let with: Fields!xxx.value when the field is not empty?
Your expression does have a little error: "," is used to separate different objects, and "&" is used to concatenate strings. When you put "," and "&" before and after, errors may occur. And you added an extra ")" to your expression.
I did a simple test, try this expression:

=IIF(IsNothing(Fields!BRIDGE_TYP_WK.Value) OR Fields!BRIDGE_TYP_WK.Value = " ", " ", "Let With: " & Fields!BRIDGE_TYP_WK.Value)

Preview:

Best regards,
Aniya

Answer 2

PhillipK 121

I managed to fix the issue with some help. A colleague alerted me with a missing comma...

=IF(isNothing(Fields!BRIDGE_TYP_WK.Value), " ","let with" & Fields!BRIDGE_TYP_WK.Value)

Share via

Getting errors with this expression

1 additional answer

Your answer