Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

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

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

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

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

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2410593
Revision : 1
Created on : 1/7/2017
Published on : 11/16/2012
Exists online : False
Views : 294