Saturday, May 28, 2011

Report is not getting displayed when migrate to MS CRM 2011 from MS CRM 4.0

After migration from MS CRM 4.0 to 2011 I faced one weird related to displaying reports in MS CRM 2011. Getting this message while loading any of the report


"Reporting Error:
The report cannot be displayed."


Additionally, the following error message is logged in the Application event log in the Microsoft Dynamics CRM 5 server:

Exception type: CrmReportingException
Exception message: The item '/OrgName_MSCRM/2011/{GUID}' cannot be found. (rsItemNotFound)


To resolve this problem, publish all reports from the computer that is running Microsoft Dynamics CRM into the computer that is running Microsoft SQL Server Reporting Services. To do this, follow these steps:

1) Click Start, click Run, type cmd, and then click OK.
2) At a Command Prompt, change the directory to the following folder:
Drive:\Program Files\Microsoft Dynamics CRM\Tools
3) Type the following command:
publishreports.exe Orgname

Note The Orgname placeholder represents the name of your organization for which you want to publish reports.

4) Press Enter.

No comments: