=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,",")