SSRS - nested IIF in the expression

Question

=iif((Fields!Company_OEM.Value = "Channel") AND (Parameters!paramCompanyOEM.Count < 2), "None", iif(Not(Fields!Company_OEM="Channel"), Count(Fields!TS_ISSUEID.Value), "None"))

Error shows and unable to run the report

Suppose the conditions (first iif) statement lies to the true part which is "None". The false part lies to the second iif statement.

Any guide? Thanks

Solution

It seems you are missing a ".Value" at the second test for "Channel". (Happens to me all the time)

=iif((Fields!Company_OEM.Value = "Channel") AND (Parameters!paramCompanyOEM.Count < 2), "None", iif(Not(Fields!Company_OEM.Value="Channel"), Count(Fields!TS_ISSUEID.Value), "None"))