Conditional Statements in the Group Header
I need to create a text object in the group header that will change depending on the grouping condition. I am attempting the following condition in a text object:
IIF(<ReportData."DeadFlag">=1,"EU Dead Flag = 1",IIF(<ReportData."DeadFlag">=0,"EU Dead Flag = 0","EU Dead Flag = Null"))
The problem is FR displays the entire condition as a text string. Can someone show me what I am doing wrong. I have been able to use variables and System variables in text objects. Maybe I am just formatting it wrong.
Thanks in advance.
IIF(<ReportData."DeadFlag">=1,"EU Dead Flag = 1",IIF(<ReportData."DeadFlag">=0,"EU Dead Flag = 0","EU Dead Flag = Null"))
The problem is FR displays the entire condition as a text string. Can someone show me what I am doing wrong. I have been able to use variables and System variables in text objects. Maybe I am just formatting it wrong.
Thanks in advance.
Comments
you kneed your [] around the whole expression.
[IIF(expression,truevalue,falsevalue)]