@Reddy: "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"
    @bruce_lcNOSPAM: "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" <email_address> wrote in message 
news:<email_address>
<quote>"
    @Reddy: "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?
<quote>"
    @Reddy: "Hi All,
IT works now. We need to change the code in where clause 
 Select company,Comp_Id, state, city from company_info
 where (Comp_Id in (@rp_comp_id) or 'All' in( @rp_comp_id'))
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 3, "forum_name": "microsoft.public.sqlserver.reportingsvcs.20140716.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}