Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
reports error

Answered reports error

  • Tuesday, 26 August, 2008 2:27 PM
     
     
    Sign In to Vote
    0
    hi all
    we have jst installed SQL 2005 and after that i found the error message when i try to run any report
    is it have any related reason ?

    Please provide me with some assistance.
     

All Replies

  • Tuesday, 26 August, 2008 3:46 PM
    Owner
     
     
    Sign In to Vote
    0

    Did you install the SRS Connector? 

    What is your environment and operating systems. 

    Are you running CRM 3 or 4

    Are SQL and CRM on the same server or different server. 

    Are you able to run the report directly from the report server?

    What is the error in the event viewer?

     

    Best Regards,

     

     

     
  • Tuesday, 26 August, 2008 6:00 PM
     
     
    Sign In to Vote
    0

    CRM 4.0

    I dont know what is the SRS Connector, so I guess I should install it?

    How to install it?

    SQL and CRM are on the same server

    If I open the CRM on the Server, and run the report, I get the same error.

     

    Maybe this detailed error can help:

     

    Microsoft CRM Error Report:
    Error Description:
    An error occurred during report rendering.

    Error Details:
    An error occurred during report rendering.

    Full Stack:
    [MissingDataSourceCredentialsException: One or more data sources is missing credentials]
       at Microsoft.Reporting.WebForms.ParametersArea.ValidateNonVisibleReportInputsSatisfied()
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

    [CrmException: An error occurred during report rendering.]
       at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.cptc_crmreports_rsviewer_reportviewer_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

    Other Message:


    Error Number:

    0x80040494
     
    ...
     
    Thanks
     
  • Tuesday, 26 August, 2008 7:01 PM
    Owner
     
     Answered
    Sign In to Vote
    0

    Yes, install the SRS Connector.  You can find the installation instructions in the implementation guide.

     

    http://www.microsoft.com/downloads/details.aspx?FamilyID=1ceb5e01-de9f-48c0-8ce2-51633ebf4714&DisplayLang=en

     

    Also, go to your report server and try to run a report directly from the report folder, not the CRM application.  You can access the Report folder on your Report server by taking the following steps

     

    http://(nameofyourCRMserver)/Reports

     

    Select Show Details in the upper right corner

    Select your Reports folder

    Select 4.0

    Select one of the reports that does not require a filter or parameter like a User report and try to run that report

     

    Let me know if you can view the report

     

     
  • Tuesday, 26 August, 2008 9:30 PM
     
     
    Sign In to Vote
    0

    I have installed the SRS Connector and it works now.

     

     

    Thank you for your help

     

     
  • Tuesday, 26 August, 2008 9:35 PM
    Owner
     
     
    Sign In to Vote
    0

    You're welcome, please mark the post as answered when time permits.

     

    Best Regards,

     

     
  • Wednesday, 27 August, 2008 12:11 AM
     
     
    Sign In to Vote
    0
    I marked it as useful... Is that what you meant?