What Maximum size of a parameter?

I have a report which I need to call from ASP.NET page. I'm trying to reportviewer control that came with Reporting Services 2000.

The report need to take a parameter more than 5000 charecters size. But when I run the report , it never responds. But if I limit the size to around 700 charesters it works fine.

So, my question is what is the maximum size allowed to set the parameter value ?

Is there any difference in SSRS 2000 and SSRS 2005 related to this issue?

[494 byte] By [Raj] at [2007-12-19]

«« fast bitmap image processing
»» Build error during msi package building

# 1

In RS2000, the length of the parameter is limited by the total length of a URL string in Internet Explorerer which is about 1600 characters.

In RS2005, this limitation has been removed and you can have parameters with longer values.

BradSyputa-MS at 2007-9-9 >

SQL Server

SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech