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

I have indicated the field and set it to call the next report where I need to
pass 4 parameters. I also set the fields parameters to the values to be
passed (2 of these are parameters in the calling report and 2 are fields on
the calling report) I set them up on next report's parameters to not have a
prompt and a set default value. When I click on the field to drilldown I get
an error message about the parameters value being 'read-only' and no report.
Can anyone help me ?
--
SusanCPromptless parameters are read only.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Susanc" <Susanc@.discussions.microsoft.com> wrote in message
news:2FFEEE63-E798-423B-863E-663035594429@.microsoft.com...
>I have indicated the field and set it to call the next report where I need
>to
> pass 4 parameters. I also set the fields parameters to the values to be
> passed (2 of these are parameters in the calling report and 2 are fields
> on
> the calling report) I set them up on next report's parameters to not
> have a
> prompt and a set default value. When I click on the field to drilldown I
> get
> an error message about the parameters value being 'read-only' and no
> report.
> Can anyone help me ?
> --
> SusanC|||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.
"Lev Semenets [MSFT]" wrote:
> Promptless parameters are read only.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Susanc" <Susanc@.discussions.microsoft.com> wrote in message
> news:2FFEEE63-E798-423B-863E-663035594429@.microsoft.com...
> >I have indicated the field and set it to call the next report where I need
> >to
> > pass 4 parameters. I also set the fields parameters to the values to be
> > passed (2 of these are parameters in the calling report and 2 are fields
> > on
> > the calling report) I set them up on next report's parameters to not
> > have a
> > prompt and a set default value. When I click on the field to drilldown I
> > get
> > an error message about the parameters value being 'read-only' and no
> > report.
> > Can anyone help me ?
> >
> > --
> > SusanC
>
>|||It does work with the prompts, thanks. I was hoping to be able to suppress
the parameters on the 2nd report.
"Lev Semenets [MSFT]" wrote:
> Promptless parameters are read only.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Susanc" <Susanc@.discussions.microsoft.com> wrote in message
> news:2FFEEE63-E798-423B-863E-663035594429@.microsoft.com...
> >I have indicated the field and set it to call the next report where I need
> >to
> > pass 4 parameters. I also set the fields parameters to the values to be
> > passed (2 of these are parameters in the calling report and 2 are fields
> > on
> > the calling report) I set them up on next report's parameters to not
> > have a
> > prompt and a set default value. When I click on the field to drilldown I
> > get
> > an error message about the parameters value being 'read-only' and no
> > report.
> > Can anyone help me ?
> >
> > --
> > SusanC
>
>|||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.
"Susanc" <Susanc@.discussions.microsoft.com> wrote in message
news:C4A4ABC5-EA9E-498E-838D-A13F6E887045@.microsoft.com...
> It does work with the prompts, thanks. I was hoping to be able to
> suppress
> the parameters on the 2nd report.
> "Lev Semenets [MSFT]" wrote:
>> Promptless parameters are read only.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Susanc" <Susanc@.discussions.microsoft.com> wrote in message
>> news:2FFEEE63-E798-423B-863E-663035594429@.microsoft.com...
>> >I have indicated the field and set it to call the next report where I
>> >need
>> >to
>> > pass 4 parameters. I also set the fields parameters to the values to
>> > be
>> > passed (2 of these are parameters in the calling report and 2 are
>> > fields
>> > on
>> > the calling report) I set them up on next report's parameters to not
>> > have a
>> > prompt and a set default value. When I click on the field to drilldown
>> > I
>> > get
>> > an error message about the parameters value being 'read-only' and no
>> > report.
>> > Can anyone help me ?
>> >
>> > --
>> > SusanC
>>|||Susanc wrote:
> It does work with the prompts, thanks. I was hoping to be able to
> suppress the parameters on the 2nd report.
>
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