I have a report which takes a string parameter and everything is fine as long as the users keep their input values under 1200 characters, however somewhere between 1200 and 1600 characters of input makes RS choke and nothing happens. IE just sits there with the globe spinning.
I tried running the query which accepts the string parameter as a varchar(8000) and everything is fine which leads me to conclude that something is going on inside RS.
I'm running the report from Report Manager.
String parameters with values of over 1200 characters causes problems
LauraBu
If you're in SQL 2000, you're running into a IE limitation on the length of the URL Access string (it's somewhere around 1600).
In 2005, there is some additional logic which will bypass the use of URL Access if the querystring is really large.
If you *must* pass a string this long and you're on SSRS 2000, consider using POST. Here is an example:
http://blogs.msdn.com/bryanke/articles/73153.aspx< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />