Prev: Localization
Next: displaying unicode characters in report
From: StMaas on 10 Oct 2006 14:03
I've created a report that includes a multi-value parameter, however when
more than one value is seelcted from the list the report produces an error
that references "Incorrect Syntax near ",".
How do I correct this?

From: Bruce L-C [MVP] on 10 Oct 2006 14:07
Show how you are using the parameter.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"StMaas" <StMaas(a)discussions.microsoft.com> wrote in message
news:A4B88054-4FAE-4D62-BEF0-8B282C787E9E(a)microsoft.com...
> I've created a report that includes a multi-value parameter, however when
> more than one value is seelcted from the list the report produces an error
> that references "Incorrect Syntax near ",".
> How do I correct this?
>


From: RajDeep on 11 Oct 2006 03:08
Send the Query where you are using this parametre.For Multivalue you
should use "in" keyword instead of "="
hope this might be your problem

Bruce L-C [MVP] wrote:
> Show how you are using the parameter.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "StMaas" <StMaas(a)discussions.microsoft.com> wrote in message
> news:A4B88054-4FAE-4D62-BEF0-8B282C787E9E(a)microsoft.com...
> > I've created a report that includes a multi-value parameter, however when
> > more than one value is seelcted from the list the report produces an error
> > that references "Incorrect Syntax near ",".
> > How do I correct this?
> >

 | 
Pages: 1
Prev: Localization
Next: displaying unicode characters in report