Tuesday, February 14, 2012

display error

in the report desingner textbox cant display the value like this. what is the error. those are multivalues.

=CStr(Parameters!BU.Value)

A mutli-valued parameter is represented as an array of values, so if you want the first value:

=CStr(Parameters!BU.Value(0))|||result is [acc code].[bu].&[1] but i need to get the real value like bu1, bu2 etc:
|||

From the sounds of it you are using reporting services - If so I think you need to use:

Parameters!BU.Label

No need fo cstr either

HTH

|||that give some error.
|||

How about:

Parameters!BU.Label(0)

|||found the answer: JOIN(Parameters!BU.Label,",")

No comments:

Post a Comment