sql server reporting services: Drillthrough to report gives 'read-only' error on parameters -- sql server reporting services

Re: Drillthrough to report gives 'read-only' error on parameters

Susanc
1/9/2005 2:33:04 PM

Okay. Then how do you suppress the second reports parameters at the top and
provide them via the link. Sorry, I am somewhat of a beginner with Reporting
Services. Thanks much for the help.

[quoted text, click to view]

Re: Drillthrough to report gives 'read-only' error on parameters

Susanc
1/9/2005 2:45:02 PM

It does work with the prompts, thanks. I was hoping to be able to suppress
the parameters on the 2nd report.

[quoted text, click to view]

Re: Drillthrough to report gives 'read-only' error on parameters

Lev Semenets [MSFT]
1/9/2005 6:11:11 PM

Starting with SP1 it is possible to create hidden parameters. Please look
into SRS SP1 readme file for more information
(
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_report_manager_parameters )

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Drillthrough to report gives 'read-only' error on parameters

Frank Matthiesen
1/10/2005 5:04:12 PM

[quoted text, click to view]

Hi Susan,

publish your report to the server, open Report Manager and then do the
following:
check "Has Default Value"
check "NULL"
check "Prompt for User"
AND
clear "Prompt String" -Textbox

that worked for me. I've tried to figure it out within visual studio. It
doesn't work.
But if the report is published to the server and manipulated in report
manager with the steps above.. it works.....seems to be a MS-feature ;-)
and If you call your report in the following URL-Type
http://sql/ReportServer?/KKM/MYREPORT&Month=Jan+2004&KTR=KTR&rs:Command=Render&rs:Format=HTML4.0
the user can not expand the toolbar

Hope that helps

regards

Frank
www.xax.de

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.