hi, i am trying to build a multi value parameter SSRS report for my client. http://stackoverflow.com/questions/10830063/large-number-of-values-in-a-multi-value-parameter i have a situation very similar to the above.i have to display about 3800 agents in the drop down menu of the parameter.i am passing the parameter using IN function in SQL where it looks up the value from a table. i get the following error: http://stackoverflow.com/questions/10911610/ssrs-webpage-error-status-code-500 any way to work around this ? request for help on this

Hi, As descibed in posts, Have you changed the web.config file of reportserver and report manager to set the value for aspnet:MaxHttpCollectionKeys? Are you still getting error ?- Chintak (My Blog)

HI Pavan ! According to the below mentioned supprt KB from Microsoft; http://support.microsoft.com/kb/2661403 ASP.NET requests that have lots of form keys, files, or JSON payload receive an error response from the server. Resolution : Add the following section in your Report Manager Web.Config file; <configuration> <appSettings> <add key="aspnet:MaxJsonDeserializerMembers" value="1000" /> <add key="aspnet:MaxHttpCollectionKeys" value="1000" /> </appSettings> </configuration> Set the value to "2000" or bigger according to your requirement. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

HI Pavan ! According to the below mentioned supprt KB from Microsoft; http://support.microsoft.com/kb/2661403 ASP.NET requests that have lots of form keys, files, or JSON payload receive an error response from the server. Resolution : Add the following section in your Report Manager Web.Config file; <configuration> <appSettings> <add key="aspnet:MaxJsonDeserializerMembers" value="1000" /> <add key="aspnet:MaxHttpCollectionKeys" value="1000" /> </appSettings> </configuration> Set the value to "2000" or bigger according to your requirement. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

Main issue is i dont have access or control of the report server.reports will be deployed on sharepoint. request to please help on this