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
For those still struggling with this issue:
The good news is that Update Rollup (16) for Microsoft Dynamics CRM 4.0 seems to address the issue: http://support.microsoft.com/kb/2477743
To quote the notes, it says the following issue has been resolved:
Assume that you create a custom report in an instance of Microsoft SQL Server 2008.
Additionally, the report contains the CRM pre-filtering criteria.
When you run the report, you receive the following error message:
Reporting Error. The report cannot be displayed
Error Number: 0x80040494 Error Description: The report parameter ‘P1’ is read-only and cannot be modified. (rsReadOnlyReportParameter)