Using IsNull Formatting Rule in NPrinting

[kdmarkee]

I'm using a table loaded in my Levels node for a pixel perfect report, my detail band is using that level, and I am trying to conditionally hide a field in that detail band if the field is null (ie... IsNull([CH334_Level.Reason Code]))but cannot seem to get it working.  What am I missing here?  Thanks.

[Lech_Miszkiewicz]

Hi Kris,

I am not sure If I understand ... what do you mean by: I am trying to conditionally hide a field in that detail band if the field is null (ie... IsNull([CH334_Level.Reason Code]))?

First of all to use conditional formatting rule you need to have field in the band where condition is applied, then you can make font, borders colours formatting based on value, but I dont think you can actually exclude column as the actual condition seems to be evaluated on row-by-row basis

[Ruggero_Piccoli]

Hi,

It could be that null values are interpreted as empty strings. Try to modify the formula like:

IsNull([CH334_Level.Reason Code])) Or [CH334_Level.Reason Code] == ""

Best Regards,

Ruggero