Select the product you need help with

You receive "The report parameter 'P1' is read-only and cannot be modified" when rendering a custom report in Microsoft Dynamics CRM when using SQL Server Reporting Services 2008 R2

Article ID: 2410593 - View products that this article applies to.

Symptoms

After you upload a custom report into Microsoft Dynamics CRM that uses CRM pre-filtering and you use SQL Server Reporting Services 2008 R2, an error message is received:

Unexpected Error

An error has occurred.

Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support.

Development errors may provide the following details:

Error Message: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)

Back to the top | Give Feedback

Cause

The issue is due to schema changes made to SQL Server Reporting Services 2008 with the R2 release to enhance report layouts and visualizations.

Back to the top | Give Feedback

Resolution

To resolve the error message, update the report parameters in the SQL Server Reports Manager to Prompt User for the parameters created by CRM.

For Microsoft Dynamics CRM 4.0:

1) Navigate to the Reports Manager website (i.e. http://<ServerName>/Reports)

2) Click to open the <ORGNAME>_MSCRM folder

3) Click on Details View

4) Click on the 4.0 folder

5) Select the Dropdown menu next to the GUID value associated with the report, and select Manage.

6) Select Parameters.

7) For the P1 Parameter, mark the Hide checkbox

8) Repeat Step #7 for all P<#> Parameters that exist and also and CRM_<NAME> Parameters that exist

9) Click Apply to save changes

For Microsoft Dynamics CRM 2011:

1) Navigate to the Reports Manager website (i.e. http://<ServerName>/Reports)

2) Click to open the <ORGNAME>_MSCRM folder

3) Click on Details View

4) Click on the Custom Reports folder

5) Select the Dropdown menu next to the GUID value associated with the report, and select Manage.

6) Select Parameters.

7) For the P1 Parameter, mark the Hide checkbox

8) Repeat Step #7 for all P<#> Parameters that exist and also and CRM_<NAME> Parameters that exist

9) Click Apply to save changes

Back to the top | Give Feedback

More information

Full Stack error:

Microsoft CRM Error Report:

Error Description: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)

Error Details: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)

Full Stack: [ReportServerException: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)] at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage() [CrmReportingException: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)] at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.] at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.test_crmreports_rsviewer_reportviewer_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\82ce50f4\e77f4ed8\App_Web_rvn8i4v5.0.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Other Message:
Error Number: 0x80040494
Source File: Not available
Line Number: Not available

Date: 09-10-2010

Time: 14:32:32

Server: localhost
Request URL: http://localhost:5555/Test/CRMReports/rsviewer/reportviewer.aspx

Back to the top | Give Feedback

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback