Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you run a report in Microsoft Dynamics CRM 4.0: "The report cannot be displayed"

Error message when you run a report in Microsoft Dynamics CRM 4.0: "The report cannot be displayed"

View products that this article applies to.

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 On 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 the MSCRM data source in Microsoft SQL Server Reporting Services (SSRS), you 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.

↑ Back to the top

Cause

Cause 1

This 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.

Cause 2

The data string is not changed after you install Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services.

↑ Back to the top

Resolution

Resolution 1

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

Resolution 2

Manually change the connection string and the data sources that must be changed. To do this, follow these steps:
  1. Open Reports Manager.
  2. Select the CRM Organization.
  3. Click Show Details.
  4. Click the v4 folder.
  5. Click the CRM Data Source.

    When you are using Windows Authentication, the connection string will resemble the following:
    Data Source=server;Initial Catalog=ORG_MSCRM;Integrated Security=SSPI
    With Windows integrated authentication radio selected.
    When you use Microsoft CRM Data Extension, the connection string resembles the following:
    MSCRM Data Connector Connection String
    With Credentials Supplied by the user running the Report.

↑ Back to the top

More Information

For more information about a similar problem, click the following article number to view the article in the Microsoft Knowledge Base:

946585 Error message when you run a report in Microsoft Dynamics CRM 4.0: "Reporting Error. The report cannot be displayed"

↑ Back to the top

Keywords: kb, kbmbspilot, kbexpertiseinter, kbprb, kbmbsmigrate, kbtshoot, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 946289
Revision : 2
Created on : 4/16/2020
Published on : 4/16/2020
Exists online : False
Views : 555