Table - Row - Conditional Formatting

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

    Posted 20 Mar 2018 Link to this post

    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.


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

    Posted 06 Apr 2018 in reply to Brian Link to this post


    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?


Back to Top