Could some body explain =Array.IndexOf() Function in SSRS and How to use in SSRS Parameters or fields with an example
Thanks in Advance
Technology Tips and News
Could some body explain =Array.IndexOf() Function in SSRS and How to use in SSRS Parameters or fields with an example
Thanks in Advance
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.