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

Answer 1

try:

Count(Fields!TS_ISSUEID.Value).toString()

Answer 2

Check this out

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

Let me know if your problem resolved or not

Answer 3

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"))