Hi Guys, In my previous project, I was facing one issue related to parameter value in SSRS 2008. I had one parameter P_Series_Number. This parameter was single value or multi value parameter. I created a dataset with below query to generate a number series from 1 to 10000. Then I mapped this dataset to P_Series_Number parameter. When I was rendering report, it was throwing an error that parameter value can’t be more the 999. So what I thought that limitation of value of a parameter is 999. But in my current project (Different system), I tried same and it is accepting more than 999 value. I would like to know that there is any setting we need to do to increase or decrease this limit. Anyone, who has faced similar kind of issue please explain. T-SQL to generate a number series BEGIN WITH GenerationNumberSeriesCTE AS (SELECT 1 EMP_ID UNION ALL SELECT EMP_ID + 1 FROM GenerationNumberSeriesCTE WHERE EMP_ID + 1 < = 10000) SELECT EMP_ID FROM GenerationNumberSeriesCTE OPTION (MAXRECURSION 0) End http://www.saqib-ansari.com/2010/02/generate-series-using-t-sql.html Thanks Shiven:)

Hi S Kumar Dubey, I have verified this on my SSRS 2008 as well, and did not find any limitation if I have specified 999 values. Therefore, I would like to know the exact error message that you experienced in your previous project. The error message can help us gain more detailed information. As far as I know, there is a limitation regarding the URL size. Maybe you can have a look at it, Maximum URL length is 2,083 characters in Internet Explorer http://support.microsoft.com/kb/208427 Thanks, Eileen