Microsoft KB Archive/946289

= Error message when you run a report in Microsoft Dynamics CRM 4.0: &quot;The report cannot be displayed&quot; =

Article ID: 946289

Article Last Modified on 1/3/2008

-

APPLIES TO


 * Microsoft Dynamics CRM 4.0

-



RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.



SYMPTOMS
When you run a report in Microsoft Dynamics CRM 4.0, you receive the following reporting error message:

Reporting Error

The report cannot be displayed.

If the DevErrors parameter is set to &quot;On&quot; in the Web.config file, 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

Source Error:

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.

Stack Trace:

[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.Control.PreRenderRecursiveInternal +77

System.Web.UI.Control.PreRenderRecursiveInternal +161

System.Web.UI.Control.PreRenderRecursiveInternal +161

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

When you verify the properties of MSCRM data source in SQL Server Reporting Services (SSRS), you may receive the following error message:

The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly.



CAUSE
This problem occurs because the custom data processing extension used by Microsoft Dynamics CRM 4.0 is registered incorrectly on the SQL Server Reporting Services server. This behavior may occur if the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services has been uninstalled or if it is configured incorrectly.

If you install the following Critical Update for SQL Server 2005 Service Pack 2, the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services will be removed:http://www.microsoft.com/downloads/details.aspx?FamilyId=D09CF5C4-FEC4-4322-9FEE-06A43401CF0C&displaylang=en



RESOLUTION
To resolve this problem, repair or reinstall the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services.



MORE INFORMATION
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Keywords: kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB946289

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.