This is a migrated thread and some comments may be shown as answers.

Table - Row - Conditional Formatting

1 Answer 82 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 20 Mar 2018, 08:33 PM

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?

1 Answer, 1 is accepted

Sort by
0
Michael
Top achievements
Rank 1
answered on 06 Apr 2018, 02:06 PM

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

Tags
Report Designer (standalone)
Asked by
Brian
Top achievements
Rank 1
Answers by
Michael
Top achievements
Rank 1
Share this question
or