Display multi value parameter LABEL

Hello.
I have a multi value parameter in my report.
I want to know how can I display all of the selected values in this
parameter in a text box.
Whan I try to use this parameter in a textBox it automaticly take the
value:
Parameter.param.Value(0) Whice take only the first select value.
Is there a simple way of doing it?
Thanks.Ok.
I found it -
=3DJoin(Parameter!param1.value,",")
Thanks.
nicknack =D7=9B=D7=AA=D7=91:
> Hello.
> I have a multi value parameter in my report.
> I want to know how can I display all of the selected values in this
> parameter in a text box.
> Whan I try to use this parameter in a textBox it automaticly take the
> value:
> Parameter.param.Value(0) Whice take only the first select value.
> Is there a simple way of doing it?
> Thanks.|||On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> Ok.
> I found it -
> =3DJoin(Parameter!param1.value,",")
> Thanks.
> nicknack =D7=9B=D7=AA=D7=91:
> > Hello.
> > I have a multi value parameter in my report.
> > I want to know how can I display all of the selected values in this
> > parameter in a text box.
> > Whan I try to use this parameter in a textBox it automaticly take the
> > value:
> > Parameter.param.Value(0) Whice take only the first select value.
> > Is there a simple way of doing it?
> > Thanks.
Good thing to know.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||What if the user selects All and the list of items is very long. For example
vendors you sell their items? How can you show "All Vendors" instead of the
very long list of names. It overruns the report.
--
cjm
"EMartinez" wrote:
> On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> > Ok.
> > I found it -
> > =Join(Parameter!param1.value,",")
> >
> > Thanks.
> >
> > nicknack ×?ת×?:
> >
> > > Hello.
> > > I have a multi value parameter in my report.
> > > I want to know how can I display all of the selected values in this
> > > parameter in a text box.
> > > Whan I try to use this parameter in a textBox it automaticly take the
> > > value:
> > > Parameter.param.Value(0) Whice take only the first select value.
> >
> > > Is there a simple way of doing it?
> >
> > > Thanks.
>
> Good thing to know.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||If, for example, you had a list of 25 vendors you could use:
= IIF(Parameters!Vendors.Count = 25, "All Vendors",
(JOIN(Parameters!Vendors.Label, ", ")))
Just adjust the number the .Count equals to the total number of values in
your parameter list.
"cmayers" wrote:
> What if the user selects All and the list of items is very long. For example
> vendors you sell their items? How can you show "All Vendors" instead of the
> very long list of names. It overruns the report.
> --
> cjm
>
> "EMartinez" wrote:
> > On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> > > Ok.
> > > I found it -
> > > =Join(Parameter!param1.value,",")
> > >
> > > Thanks.
> > >
> > > nicknack ×?ת×?:
> > >
> > > > Hello.
> > > > I have a multi value parameter in my report.
> > > > I want to know how can I display all of the selected values in this
> > > > parameter in a text box.
> > > > Whan I try to use this parameter in a textBox it automaticly take the
> > > > value:
> > > > Parameter.param.Value(0) Whice take only the first select value.
> > >
> > > > Is there a simple way of doing it?
> > >
> > > > Thanks.
> >
> >
> > Good thing to know.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. SQL Server Developer
> >
> >