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

Applies to: Dynamics CRM 4.0

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)


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.

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



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