Does the parameter of a report has has length limitation?

Hi,
I tried to pass a long sql statement(about 2000 characters) as the parameter
of a report by ReportingService.Render() function, but it always encountered
an exception.
So What's is the max length of a parameter by using web service method?
Thanks.What kind of exception?
What version of RS ?
As far as I know there is no limit is parameter length, especially for web
service method.
But there is definitly a problem with HTML4.0 rendering if a query string is
above 2K in length in RS 2000. RS chocks on that.
I'm using a work around by storing sql statement (parameters) in a separate
table and pass a returned record id from that table
to the reporting server. a stored procedure or a set of sql statements can
retreive that values based on passed id and execute them.
Kind of two step execution, but it works for long parameters.
If you POST to RS - there is no such thing as a query string, but HTML4.0
rendering is still a problem. See above.
"David Zhu" <DavidZhu@.discussions.microsoft.com> wrote in message
news:0BBD7B75-DACB-4710-B863-BCDF6C59E996@.microsoft.com...
> Hi,
> I tried to pass a long sql statement(about 2000 characters) as the
> parameter
> of a report by ReportingService.Render() function, but it always
> encountered
> an exception.
> So What's is the max length of a parameter by using web service method?
> Thanks.
>|||Thank you very much!
"Oleg Yevteyev" wrote:
> What kind of exception?
> What version of RS ?
> As far as I know there is no limit is parameter length, especially for web
> service method.
> But there is definitly a problem with HTML4.0 rendering if a query string is
> above 2K in length in RS 2000. RS chocks on that.
> I'm using a work around by storing sql statement (parameters) in a separate
> table and pass a returned record id from that table
> to the reporting server. a stored procedure or a set of sql statements can
> retreive that values based on passed id and execute them.
> Kind of two step execution, but it works for long parameters.
> If you POST to RS - there is no such thing as a query string, but HTML4.0
> rendering is still a problem. See above.
> "David Zhu" <DavidZhu@.discussions.microsoft.com> wrote in message
> news:0BBD7B75-DACB-4710-B863-BCDF6C59E996@.microsoft.com...
> > Hi,
> >
> > I tried to pass a long sql statement(about 2000 characters) as the
> > parameter
> > of a report by ReportingService.Render() function, but it always
> > encountered
> > an exception.
> >
> > So What's is the max length of a parameter by using web service method?
> >
> > Thanks.
> >
>
>