SSRS reports doesn't reneder when i select all filters
I have a SSRS Report that has been deployed on Sharepoint 2010 portal.I have 9 parameters for this report.When I select all in every parameter and press apply button, apply button greyed out for 3 secs and report never renders and apply button is active again.If i reduce my filters in parameters the report renders as expected.Is there any limit for filters in SSRS?cause this report was working for every selection in parameters till last month. Thanks Pavanaaa
February 9th, 2012 3:23pm

Hi Pavan, I had the same issue when i deployed my report in sharepoint 2010. I had only 3 parameters and I think the word limit of all the parameters must not exceed 5000 charectors. It will not run the report if it have more than 5000 words. I think there is no solution unless if you filter our some data. In my case i have created a search textbox as my first parametre and user will type in the word and based on that criteria parametere 2 and Parametere 3 will gives me the values. I hope you find a better solution but as far as i know there is no solution for this. Dasari
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2012 4:22pm

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" /> </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
July 29th, 2012 5:50pm

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: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
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2012 5:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics