Thursday, March 26, 2015

Using IIF and AND in SSRS Expression


It has something to do with SSRS not able to parse the zero(0) as it returns it as string rather than as an integer.



Um, what? SSRS is quite capable of handling 0's...


Are you trying to tell us that YOUR fields are STRINGs and not INTEGERS?



=IIF(Fields!PastVal.Value+Fields!DatePay+Fields!Line.Value='000',False,True)





Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.


No comments:

Post a Comment