How to submit a report parameter?

Microsoft® SQL Server� Reporting Services provides a single entry point to the full functionality of the report server: the Reporting Services Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server. The Web service and its methods expose the functionality of the report server and allow you to create custom tools for any part of the report life cycle, from management to execution.
The application that we have build is using the Web Service and the .NET Framework. We have successfully created the proxy class for the Web service.
We are trying to:
Create a ReportServices control
Create a ReportViewer control
Render a specific Report
To render the Report, we need to pass it a string paramter.
Our status is the following:
We have successfully created the ReportServices control with the following:
ReportingService rs = new ReportingService();
If we don't pass a parameter, we have everthing working fine.
If we pass a parameter, the report does not render. A summary of the error message follows:
"The report parameter 'sDealerId' is read-only and cannot be modified."
The full error message follows:
<detail>
<ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParameter</ErrorCode>
<HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
<HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
<ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName>
<ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductVersion>
<ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
<OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem>
<CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId>
<MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsReadOnlyReportParameter" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>
Has anyone ever successful passed parameters to a ReportServices and/or ReportViewer control? If so, have you ever seen this type of error message and do you know which specific security issue is causing this?
Thanks,
Robert Baker
ZxytekNot sure, Robert, but this sounds like the error that version 1 gives when
you try to update a parameter that has been rendered "read only". SP1
removed this limitation allowing you to keep a parameter hidden and yet
change it's value via the URL.
"zxytek" <zxytek@.hotmail.com> wrote in message
news:252C34F9-652F-494C-BBE7-807B07073216@.microsoft.com...
> Microsoft® SQL ServerT Reporting Services provides a single entry point to
the full functionality of the report server: the Reporting Services Web
service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP
and acts as a communications interface between client programs and the
report server. The Web service and its methods expose the functionality of
the report server and allow you to create custom tools for any part of the
report life cycle, from management to execution.
> The application that we have build is using the Web Service and the .NET
Framework. We have successfully created the proxy class for the Web
service.
> We are trying to:
> Create a ReportServices control
> Create a ReportViewer control
> Render a specific Report
> To render the Report, we need to pass it a string paramter.
> Our status is the following:
> We have successfully created the ReportServices control with the
following:
> ReportingService rs = new ReportingService();
> If we don't pass a parameter, we have everthing working fine.
> If we pass a parameter, the report does not render. A summary of the
error message follows:
> "The report parameter 'sDealerId' is read-only and cannot be
modified."
> The full error message follows:
> <detail>
> <ErrorCode
xmlns="rsReadOnlyReportParam">http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParam
eter</ErrorCode>
> <HttpStatus
xmlns="400</HttpStatus>">http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
> <Message
xmlns="The">http://www.microsoft.com/sql/reportingservices">The report parameter
'sDealerId' is read-only and cannot be modified.</Message>
> <HelpLink
xmlns="http://go.microsoft.c">http://www.microsoft.com/sql/reportingservices">http://go.microsoft.c
om/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utili
ties.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName
=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
> <ProductName
xmlns="Microsoft">http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server
Reporting Services</ProductName>
> <ProductVersion
xmlns="8.00.878.00</ProductV">http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductV
ersion>
> <ProductLocaleId
xmlns="127</ProductLocaleId>">http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
> <OperatingSystem
xmlns="OsIndependent</Operat">http://www.microsoft.com/sql/reportingservices">OsIndependent</Operat
ingSystem>
> <CountryLocaleId
xmlns="1033</CountryLocaleId">http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId
> <MoreInformation
xmlns="">http://www.microsoft.com/sql/reportingservices">
> <Source>Microsoft.ReportingServices.Processing</Source>
> <Message msrs:ErrorCode="rsReadOnlyReportParameter"
msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft
.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtI
D=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20
Services&ProdVer=8.00"
xmlns:msrs="The">http://www.microsoft.com/sql/reportingservices">The report
parameter 'sDealerId' is read-only and cannot be modified.</Message>
> </MoreInformation>
> <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
> </detail>
> Has anyone ever successful passed parameters to a ReportServices and/or
ReportViewer control? If so, have you ever seen this type of error message
and do you know which specific security issue is causing this?
> Thanks,
> Robert Baker
> Zxytek