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.

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 4:01PM
    if trying to display result in a memo(text object
    you kneed your [] around the whole expression.
    [IIF(expression,truevalue,falsevalue)]

    ;)
  • edited 4:01PM
    That did it. Thank you!

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.