Wednesday, March 28, 2012

Multi select parameter dropdown

Hi there,
Does anyone know if it is possible to make drop down parameters multiple select? Much like one can in a list box by holding down ctrl and clicking on the records, but for parameters.
Please any help will be great.
RegardsIn box?
How could I let parameter accept multi value in a textbox?
Just like i want two parameter values "2003, 2004" in one parameter textbox,
then select the product in 2003 and 2004?
My syntax is..
Select A,B,C From XYZ Where (A in (@.Aparameter) or @.Aparameter='')
How should I do?
Thanks!
Angi
"Myles" <Myles@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:5F9259CD-6036-4F16-B26E-C694085DD0CB@.microsoft.com...
> I believe you can select multiple rows in a drop down, but I don't believe
that Reporting Services (out of the box) will accept multiple values for a
parameter. There may be a way to use the WebService, however - there is a
ReportParameter.MultiValue Property available in there - it is read only,
however. Is it possible to have multi valued parameters using the web
service?
> "PLSH" wrote:
> > Hi there,
> >
> > Does anyone know if it is possible to make drop down parameters multiple
select? Much like one can in a list box by holding down ctrl and clicking on
the records, but for parameters.
> >
> > Please any help will be great.
> >
> > Regards

No comments:

Post a Comment