Showing posts with label passing. Show all posts
Showing posts with label passing. Show all posts

Friday, March 30, 2012

Report parameter read only

Got this error message while trying to load a sub-report from an existing
report and passing a parameter into the sub-report. I created the report
parameter just like it did for the source report. Please help.That means you forgot to provide a Prompt for the parameter in the
subreport.
Omitting the Prompt indicates to the server that the user should not be
prompted for a value (hence: read-only).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"John Cosmas" <vabo214@.msn.com> wrote in message
news:OKnfI3WZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Got this error message while trying to load a sub-report from an existing
> report and passing a parameter into the sub-report. I created the report
> parameter just like it did for the source report. Please help.
>

Report Parameter Length

We are planning on passing in an XML document as a report parameter but have
not been able to determine if there is a maximum parameter length. Does SQL
Reporting Services 2000 have a maximum parameter length?
Thanks.I can only partially answer your question... If you are passing the parameter
via URL then you are constrained by the max URL length ( might be 255 I
think)..
YOu can pass the info INSIDE the HTML which removes the URL restriction...
There are examples in Books on line - search for URL under Reporting Services
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"RobinB" wrote:
> We are planning on passing in an XML document as a report parameter but have
> not been able to determine if there is a maximum parameter length. Does SQL
> Reporting Services 2000 have a maximum parameter length?
> Thanks.

Monday, March 26, 2012

Report not rendering properly when passing prms in url

This has probably been answered before, but i cannot find the
solution.. I need to pass prms to a packlist report to pull the correct
packlist once a user is finished with a shipment in our logistics
software. Whenever i pass in the prms the report comes up, but there
are no graphics. I am also using neodynamics barcoding software and
those do not appear either.
Here is the url w/prms i am using :
http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
Any ideas?
Thanks
JayDialDid you Deploy your graphics to the server as well?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145889309.197930.223470@.e56g2000cwe.googlegroups.com...
> This has probably been answered before, but i cannot find the
> solution.. I need to pass prms to a packlist report to pull the correct
> packlist once a user is finished with a shipment in our logistics
> software. Whenever i pass in the prms the report comes up, but there
> are no graphics. I am also using neodynamics barcoding software and
> those do not appear either.
> Here is the url w/prms i am using :
> http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
> Any ideas?
> Thanks
> JayDial
>|||The graphics display fine if i browse to the actual report, but not if
i provide the prms in the url.|||Next question is: does the report return a result set with the parms you've
specified? I'm thinking that if no rows are returned then your graphics may
not show up either. Does this work when you preview the report using those
parms?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145892373.787538.120860@.y43g2000cwc.googlegroups.com...
> The graphics display fine if i browse to the actual report, but not if
> i provide the prms in the url.
>|||Hrmm, that is the strangest thing. Today i was getting a couple screen
shots for you, but now the graphics are showing up. I thought maybe it
was a problem with the original url I was using, but when i copy and
paste from the original post everything is to be expected! Thanks for
your help!
-JayDial