[Thinus du Pisanie]

Good day

I have a problem I can't solve.I am writing a report and want to ask if it is possible.

The statement or expresion to show data in report is usually like this:

[b]Fields!KPA_Weght_Result.Value[/b]

What I want to do is the text displaying in the report must change to certain text if it shows a certain text.

Now the statement in expression I want to run is:

[b]IIF(Fields!KPA_Weght_Result.Value='Hello')[/b]

Then the text must change to "Hi"

Do you know in any way how to do statement. Because I tried this that works.

=IIF(Fields!KPA_Weght_Result.Value >= 4, "Green")

But this doesn't

=IIF(Fields!KPA_Weght_Result.Value = "Hello", "Hi")

Regards

[andrewsw]

How can the weight-result value be both a number (>= 4) and a word ("Hello")..?

[Thinus du Pisanie]

Don't worry about the column name just the principle want to figure out.

[andrewsw]

Thinus du Pisanie, on 18 February 2013 - 07:12 AM, said:

Don't worry about the column name just the principle want to figure out.

IIF has three parameters and you shouldn't skip the third one (return value if false).

[Thinus du Pisanie]

Thanks it works