Could some body explain =Array.IndexOf() Function and How to use in SSRS Parameters or fields ??

Could some body explain =Array.IndexOf() Function in SSRS and How to use in SSRS Parameters or fields with an example

Thanks in Advance

June 26th, 2015 8:13am

Array.IndexOf can be used to search an array object (such as a multivalue parameter) to return the - based position of a value.

Example:

Parameters!colors.Value = orange,yellow,blue

=Array.IndexOf(Split(Parameters!colors.Value.ToString(), ","), "blue")

Returns 2.

Free Windows Admin Tool Kit Click here and download it now
June 26th, 2015 10:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics