Hi, I had developed a SSRS report in 2008 version. In this report I have one parameter with multiple selection enabled. If a user is selected "Select All" option it is throughing the error "maximum 255 characters" like that. So I want to find out the value of parameter before passing to the main query. I used IIF(Len(parameters!costregion.value) > 255,false,true) in the visibility of the main Tablix properties. But it is showing error only. it is not reading this condition I guess. How to stop accessing the main query if a user is selecting more values beyond the limitation in a multiple parameter values instead of giving some default error i want to display some message.

I'd guess that the issue is with the query, not the parameter. In fact, I'd guess that you are trying to pass a multi-valued parameter to a stored procedure and that the parameter data type is something like a VarChar(255). If the parameter works when the user select 2 or 3 values, then you should be able to alter the stored procedure so that the parameter is a VarChar(MAX). If it bombs out anytime you select more than 1 value, take a look at this thread... SQL Query for user submitted values Jason Long

I'd guess that the issue is with the query, not the parameter. In fact, I'd guess that you are trying to pass a multi-valued parameter to a stored procedure and that the parameter data type is something like a VarChar(255). If the parameter works when the user select 2 or 3 values, then you should be able to alter the stored procedure so that the parameter is a VarChar(MAX). If it bombs out anytime you select more than 1 value, take a look at this thread... SQL Query for user submitted values Jason Long

Hi, Thanks for your reply. As you told i verified the backend data type size it is 255 only. But after I change this 255 I am getting the following error. Query execution failed for dataset 'ds_Main' ORA-01795: maximum number of expression in a list is 1000 What this mean? In a multiple selection parameter we need to select only 1000 items ? Urs Sridhar

Hi, Thanks for your reply. As you told i verified the backend data type size it is 255 only. But after I change this 255 I am getting the following error. Query execution failed for dataset 'ds_Main' ORA-01795: maximum number of expression in a list is 1000 What this mean? In a multiple selection parameter we need to select only 1000 items ? Or how to identify the "select all" option is selected or not. if so then i can give some custom error message instead throwing default error message. Urs Sridhar

Query execution failed for dataset 'ds_Main' ORA-01795: maximum number of expression in a list is 1000 Hi Urs Sridhar, Based on my research, this error is from Oracle database, it seems you cannot put more than 1000 values in 'in clause', are you using Oracle datasource? if so, I would recommend you post your issue at Oracle forum to get a specified support. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

So u mean due to limitation in ORACLE I am getting this error. Ok I will check on that. Can anybody help me to know the what is the maximum no. of character we can type in a textbox in SSRS 2008? And I have developed the reports in 2008 version. Now if i install 2008 R2 what is the impact? What i need to change? Urs Sridhar.

Can anybody help me to know the what is the maximum no. of character we can type in a textbox in SSRS 2008? And I have developed the reports in 2008 version. Now if i install 2008 R2 what is the impact? What i need to change? Hi Sridhar, The maximum length of a textbox (all characters in one textbox) is 32000 characters. You can install both SSRS 2008 and SSRS 2008 R2 at the same server. Please remember to mark the replies as answers if they help and unmark them if they provide no help.