IIF Function and Report Parameters

[Bryan Hughes]

Not sure how I can make this work.  I get "Cannot perform '=' operation on System.Object[] and System.Int32"

Thanks for the help -- Bryan H

= IIf(Parameters.ParameterServiceTypeID.Value = 0, "Services: All", "Service: " + Fields.ServiceTypeName)

[Steve]

Hello Bryan,

As noted in the Functions help article, the reporting engine first evaluates the function parameters (i.e. both parameters are evaluated prior to the function execution) and then passes the result values to the function. This means that you need to make sure the parameters of the function are valid statements prior to executing the function.

The ParameterServiceTypeID parameter should be of Integer type and it should have default value. When you do not set a default/initial value or do not set such value before the report rendering, the value of the parameter is evaluated to an empty string.

Kind regards,
Steve
the Telerik team

[Bryan Hughes]

The ParameterServiceTypeID was set as Integer and value = 0.

[Bryan Hughes]

I tried IsNull in Iff expression but still same error.
= IIf(IsNull(Parameters.ParameterServiceTypeID.Value,0)=0, "Services: All", "Services: " + Fields.ServiceTypeName)

[Bryan Hughes]

I was able to make it work by using the count of field instead of Parameter value.
= IIf(CountDistinct(Fields.ServiceTypeName)> 1, "Services: All", "Service: " + Fields.ServiceTypeName)