Table - Row - Conditional Formatting

[Brian]

I am attempting to build a formatting rule to hide a row in my table.

=iif(isnull(Fields.PODetails_Comment,"")="",1,0)

My data will have null and '' (MSSQL). When running the report, it appears to work most times and others it does not.

I went as far as doing it in SQL "Case when isnull(podetails.comments,'') = '' then 1 else 0 end" then modified the expression in the conditional format to use that new field from SQL...same result.

I finally did a LEN() on the field:

=IIF(Len(fields.PODetails_Comment)>0,0,1)

Again, in most cases, the report looks fine. However, once in a while it will show the row when it should not.

Ideas?

[Michael]

Brian,

Why don't you do two conditional formatting rules, one where Fields.PODetails_Comment = <blank>

and another one where Fields.PODetails_Comment = '', set the row to not visible if either of these are true?

Mike