NULL Character

I want to group data. How do I have FR recognize the null character in a conditional statement? This is how I have it formatted but it is not what FR is looking for:

[IFF(<ReportData."Item1">=NULL,1,0)]

Your assistance will be much appreciated. Thanks in advance.

Comments

  • edited 3:48PM
    Correct condition is (do not use square brackets):

    IIF(<ReportData."Item1">=NULL,1,0)

    also be sure that Report.EngineOptions.ConvertNulls is set to False.

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.