Table - Row - Conditional Formatting

2 posts, 0 answers
  1. Brian
    Brian avatar
    33 posts
    Member since:
    Mar 2016

    Posted 20 Mar Link to this post

    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?

  2. Michael
    Michael avatar
    2 posts
    Member since:
    Apr 2018

    Posted 06 Apr in reply to Brian Link to this post

    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

Back to Top