Hi,

Thank you for the reply..

Actually,in SSRS parameter data set,we have added 'ALL' string using Union

say..

Select distinct colmn name as Param from table

union

select 'ALL'

in SQL Procedure implemented as..

...

Where Column name in @Param or @Param='ALL'

--

so,in dropdown list in SSRS,if the user selects 'ALL',the string only will be passed and if the user selects 'ALL', or with some values say 10 or 15,the performance is even good..but the user wants to use SELECT ALL (for 600 vaues selected or 599 excluding a single value) as explained above..

And i tried even with Temp table..but no performance improvement