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:
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:
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")