I am attempting to build a formatting rule to hide a row in my table.
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:
Again, in most cases, the report looks fine. However, once in a while it will show the row when it should not.