Query Limit?

Is there a limit to the size of the query for a report? I can create simple reports but when I paste in a larger query (say about 4500 characters and we will need larger queries) and try to execute the query, the report hangs in the designer. The source is a SQL Server 2000 database and this particular query only returns about 400 rows.

Thanks in advance.

Scott Lezberg
DeltekI've worked with RS2000 and the query limit is 32KB of plain text. For if I need a bigger query I create a view (or an SP, whatever you like most) and then I call it from RS.
Since I haven't used RS2005 I couldn't tell if the query is limited to 32KB.

I hope it helps.