"Reddy" wrote:

> Its a SQL statement within the report. When i select multiple values in
> company parameters it throw error saying ',' is missing. Bruce any idea, is
> my statement is wrong? or am I misssing any syntax?
>
> "Bruce L-C [MVP]" wrote:
>
> > Not sure what is wrong but in RS 2005 this should work. It is how I am doing
> > this. One question, is this statement in a stored procedure or is the SQL
> > statement directly within the report?
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Reddy" <Reddy@discussions.microsoft.com> wrote in message
> > news:81AE7C15-EACA-4B72-8A64-24B84B515B18@microsoft.com...
> > >I know post of you know the answers to my question. Here is my question.
> > >
> > > Select All option works fine in my report parameter but when I unselect
> > > select all option and select multiple value it wont work.
> > >
> > > example:
> > >
> > > Select company,Comp_Id, state, city from company_info
> > > where (Comp_Id in (@rp_comp_id) or @rp_comp_id='All'))
> > >
> > > Note: this works fine if one is company is selected in report parameter or
> > > select all is select but it wont work if I select multiple values
> > >
> >
> >