Microsoft Dynamics CRM 4.0 – The report parameter ‘P1’ is read-only and cannot be modified

You might receive the error “The report parameter ‘P1’ is read-only and cannot be modified” when uploading a custom report to CRM 4.0 when using SQL Server Reporting Services 2008 R2. The details below outlines a bit more information about this error.

The Error:

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

The 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.

The Fix:

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

1 ) Navigate to the Reports Manager website (i.e. /Reports”>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

 

All this content above can be found on the Microsoft Support knowledge base article here: http://support.microsoft.com/kb/2410593

Greg Olsen
Yellow Duck Guy