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

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

Advertisements
Categories: Dynamics CRM
  1. March 19, 2011 at 5:33 am

    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)

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: