NULL Character

jriggs

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.

AlexTZ

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.