InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 02:38:33 GMT20http://www.sqlservercentral.com/Forums/Topic1399104-1063-1.aspxHi,It looks like the general issue after the MS security update MS11-100. This security update limits the max number of form_keys to 1000. When opening the report in the Web Browser and you select the 'Select All' and the browser informs you with 'completed with error on page' is a symptom of this issue.See also [url=http://support.microsoft.com/kb/2661403/en-us]http://support.microsoft.com/kb/2661403/en-us[/url]You solve this by adding the following line in the web.config file of the ReportManager in the "appSettings" section. <add key="aspnet:MaxHttpCollectionKeys" value="3000" />Choose a value that meets your needsRegards KeesWed, 02 Jan 2013 06:05:53 GMTKees Beimanshttp://www.sqlservercentral.com/Forums/Topic1399104-1063-1.aspxI have an SSRS 2005 report (DB = SQL 2005), running on SSRS 2008 report server. There are total 6 datasets (and no stored procedures). I have four parameters, out of which one is a date field, one is a text box and the other two are multi value parameters (@PC, @CT). Out of the 6 datasets, 2 serve as providing the available values for the multi select parameters and other 4 feed the data for the report.Number of available values for @CT = 480 and that of @PC = 987.When I select all, the report runs fine in BIDS, but no data in report manager.I updated the queries populating the available values for parameters as select 'All' union select column from table.Report query:where ( @PC = 'All' or M.PC IN (@PC) ) and ( @CT = 'All' or M.CT IN (@CT) ) In the drop down, if I select 'All' for @CT and any one or two values for @PC, the report runs fine.If I select 'All' for @PC, the report doesn't return anything (in the report manager).Interestingly, if I select upto 967 individual values for @PC from the dropdown, the report runs fine. If I select 968 or anything higher than this, then the report doesn't return anything.I tried using function, split, join (tired pretty much everything that I found in google). Please help and thanks in advance.Thu, 20 Dec 2012 14:12:39 GMTpjrpjr7