Conditional Statements in the Group Header

jriggs

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.

gordk

if trying to display result in a memo(text object
you kneed your [] around the whole expression.
[IIF(expression,truevalue,falsevalue)]

jriggs

That did it. Thank you!