CODEWITHSUNDEEP
sql-server-2008reporting-servicesssrs-2008sql-server-2012-datatoolsreportserver
Alias Varghese
Alias Varghese

Reputation: 2170

Report is not loading

I have created one report with 4 parameters. one of the parameters having greater than 1000 item values.I have following issues

  1. Reporting Services don't show data after selecting parameters
  2. Reporting services displays blank page
  3. Report is working fine in Visual Studio Preview mode, but not on Report Server web server

If I reduce the number of item values of parameter to 950 Report will work fine . Is there any idea to resolve the problems without reducing number of item values of parameters?

Upvotes: 0

Views: 120

Answers (1)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

This should be related to the MaxHttpCollectionKeys default value of 1000

Add the following setting in the appSettings section of the Reporting Services config file:

<appSettings>
    <add key="aspnet:MaxHttpCollectionKeys" value="5000" />
</appSettings>

Upvotes: 1

Related Questions