Thursday, March 26, 2015

Using IIF and AND in SSRS Expression

I have a table like below



I want to hide the rows where ALL 3 columns are 0. All the columns are of INT data type


My expression is like so:



=IIF((Fields!PastVal.Value=0) AND (Fields!DatePay=0) AND (Fields!Line.Value=0),False,True)

But no data is returned except the column label(heading). What could be wrong with my express?


Thank you.




Zionlite


No comments:

Post a Comment