lk_wick


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

=CStr(Parameters!BU.Value)



Re: display error

Deepak Puri


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

=CStr(Parameters!BU.Value(0))





Re: display error

lk_wick

result is [acc code].[bu].&[1] but i need to get the real value like bu1, bu2 etc:





Re: display error

Tim Kent

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






Re: display error

lk_wick

that give some error.




Re: display error

Deepak Puri

How about:

Parameters!BU.Label(0)






Re: display error

lk_wick

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