Article ID: 946289 - View products that this article applies to.
When you run a report in Microsoft Dynamics CRM 4.0, you receive the following reporting error message:
If the DevErrors parameter is set to On in the Web.config file, you receive the following error message:
The report cannot be displayed.
When you verify the properties of the MSCRM data source in Microsoft SQL Server Reporting Services (SSRS), you receive the following error message:
Microsoft CRM Unhandled Error Details: Server Error in '/' Application.
One or more data sources is missing credentials
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.MissingDataSourceCredentialsException: One or more data sources is missing credentials
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[MissingDataSourceCredentialsException: One or more data sources is missing credentials] Microsoft.Reporting.WebForms.ParametersArea.ValidateAllReportInputsSatisfied() +65
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +643
[CrmException: An error occurred during report rendering.]
Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e) +626
Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e) +56
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +1699
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly.
Cause 1This problem occurs because the custom data processing extension that Microsoft Dynamics CRM 4.0 uses is registered incorrectly on the SSRS server. This behavior may occur if the Microsoft Dynamics CRM Data Connector for SSRS has been uninstalled or if the Microsoft Dynamics CRM Data Connector for SSRS is configured incorrectly.
If you install the following Critical Update for SQL Server 2005 Service Pack 2, the Microsoft Dynamics CRM Data Connector for SSRS will be removed:
Cause 2The data string is not changed after you install Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services.
Resolution 1To resolve this problem, repair or reinstall the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services.
Resolution 2Manually change the connection string and the data sources that must be changed. To do this, follow these steps:
For more information about a similar problem, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/946585/ )Error message when you run a report in Microsoft Dynamics CRM 4.0: "Reporting Error. The report cannot be displayed"
Contact us for more help
Connect with Answer Desk for expert help.