SSRS And Expression not working

0
votes

I have an expression in SSRS like this.

IIF(First(Fields!val.Value, "box29")="Yes" AND Sum(Fields!SortOrder.Value, "InsuranceInformation") > 1,"",

Valu val is Yes and Sortorder is 2. That is both expression satisfying. But this expression is not satisfying with AND. Any idea on this?

1
reporting-servicesssrs-2008ssrs-2012reportingservices-2005ssrs-expression
are you getting error or are you getting output for false - NiveaGM
can you please post the whole expression and errors if any or what the expression is returning? - Harry

1 Answers

0
votes

I think you need to finish your expression:

=IIF(First(Fields!val.Value, "box29")="Yes" And Sum(Fields!SortOrder.Value, "InsuranceInformation") > 1, "And expession statisfyed", "And expression not statisfyed")