Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
 Posted - 2012-02-23 : 03:14:14
|
| A recent Microsoft software upgrade with various patches was made to our Server hosting our Reporting Services solution. There were 33 patches in total…One of the issues that we noticed after this upgrade was that reports containing Multi-Select dropdown lists (which have +- 1000 items in the list) effectively caused the report to break i.e. throw a javascript error when the View Report button was clicked.This can be easily simulated on our server with a report that contains Multi-Select dropdown lists which have +- 1000 items in the list.Note, this was working perfectly before the software patch upgrade. Also, to note that the reports work fine in the local environment within VS 2008 BIDS.Effectively, something in the patch caused this not to work.Upon investigation, it seems that there is some restriction or issue with the limit on the string value on the SSRS Reports Website parsing a multi select drop down with +- 1000 itemsApparently the MaxRequestLength for a string , this is nothing new and a known issue. We investigated various suggested workarounds that effectively on “Select All” of Multi Value Parameter to pass to the dataset a DBNULL value however the issue is that the error that is thrown occurs on the website parsing the string and it doesn’t get to the database.Another workaround was to update the max request length: httpRuntime maxRequestLength="100000" executionTimeout="90000" /However this file was not modifiedAlso, we looked at the various Reporting Services javascript files used by SSRS Reports Website however these files were not modified by the software upgrade.Effectively, SSRS Reports Website is a closed packaged by Microsoft and ideally we shouldn’t be tampering with the SSRS Reports website however it seems that in this case there is an issue / error on the SSRS Reports website.Duane. |
|
|
|
|
|
Reporting Services Website throws JavaScript Error