Not accepting more than 100 customer names in the parametes in the report manager SSRS
Hi Friends, I've developed one report it is working fine in the BIDS. In one of the parameter we have 1600 customers. I deployed this report into Report Manger when I select all the customers it is showing an below Message. When I was giving top 100 customer then It is woring fine why it is not working for all the customers (1600 customer). Should we need to change anything in the report Manager? Could anyone guide me pleaseee ??? Thanks for your help
May 16th, 2012 7:25am

Hi There You can try to override the value by adding the key to the appsetttings section in your SSRS web.config file (usually in Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager) <add key="aspnet:MaxHttpCollectionKeys" value="20000" /> 20000 is just a suggestion, you can set it to the value of your choice. That might resolve your problem Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 8:29am

Thanks for your reply .... <add key="aspnet:MaxHttpCollectionKeys" value="20000" /> where can I find that SSRS Wen config file ? Thanks for your help Thanks, Rama
May 16th, 2012 8:57am

Hi there on your report server where your report server is running and it is usually in Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager) adding the key to the appsetttings section in your SSRS web.config file you can search for web.config file Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click Mark as Answer if this resolves your problem or Vote as Helpful if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 9:01am

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

Other recent topics Other recent topics