hi, i have a report having no of item in dropdown check box. few item contains () character.like soda(wash), when i select display its showing error and not showing the report. but if we select the items without (), report is displaying. I am passing the id in the stored procedure. Please reply ..

Could you please post the error message? I don't quite understand your description.

Handle these parameters in SP as string. IF @p_parameter_id <> '' SELECT @sql = @sql + ' AND table.field IN (' + @p_parameter_id + ') 'SSRSRpt

Can you see via Profile what is going on?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi, Base on your description, this parameter must be used somewhere. You can use soda(wash) instead of the parameter directly and try to preview the report again. If the same error occur, please post the error message here. In addition, a possible cause is that you don't pass multi-value parameter correctly. If so, to pass multi-value parameter, you can join every item as a string, such as: =Join(User!UserID,",") After passing the string as parameter to the stored procedure, you need to split the string to an array, for more information about how to split string, please refer to: http://blog.summitcloud.com/2010/01/multivalue-parameters-with-stored-procedures-in-ssrs-sql/ If you still do not know how to find the root cause, you can send the .rdl file of the report and its related stored procedures to sqltnsp@microsoft.com with the title "Albert Ye ThreadID: ec378d20-4e1c-4939-9480-a52280449dc1", I will check your .rdl file. If there is anything unclear, please feel free to ask. Thanks, Albert Ye

how are you passing the param to the stored procedure? and how are you querying data using the param? looks like there could be a problem, the query with () string doesnt function as designated.If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com