web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Help needed with getti...
Microsoft Dynamics CRM (Archived)

Help needed with getting reports to work

(0) ShareShare
ReportReport
Posted on by Arto Kilponen 45

Wanted outcome: A report that works.

Symptoms: Not a single report works (no matter whether I use existing or create a new one). Gives error (in Finnish, here's approximate translation): Reporting error. Report can't be shown. (rsProcessingAborted)

Things proving something is wrong: Microsoft Dynamics CRM Deployment Manager on Dynamics CRM server says "Reporting is not enabled", which in turn says "To enable reports, you must first install Microsoft Dynamics CRM Reporting Extensions for SQL Server Reporting Services. For more information, see the Microsoft Dynamics CRM Implementation Guide."

What has been tried already: Updating the Dynamics CRM 2011 to RollUp 10 on Dynamics CRM server along with SRS extension on database server. Both are now RollUp 10.

Questions: Does this Microsoft Dynamics CRM Reporting Extensions for SQL Server Reporting Services need to be installed in somewhere else than in the database server? The Dynamics CRM server doesn't have full SQL Server installed.

 

 

Please ask for any additional info that might help to get this solved.

*This post is locked for comments

I have the same question (0)
  • Arto Kilponen Profile Picture
    Arto Kilponen 45 on at

    One more thing: I don't get  " Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" type error.

     

    edit.

     

    I found the way to turn on "full error reporting". Here's more info:

    Stack Trace: 

    [ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

    [ReportServerException: Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)]

    [ReportServerException: An error has occurred during report processing. (rsProcessingAborted)]

       Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e) +82

       Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ProxyMethodInvocation.Execute(RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) +770

       Microsoft.Reporting.WebForms.ServerReport.SetDataSourceCredentials(IEnumerable`1 credentials) +401

       Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) +495

    [CrmReportingException: An error occurred during report rendering.]

       Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) +690

       Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters() +1260

       Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) +106

       System.Web.UI.Control.PreRenderRecursiveInternal() +113

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

     

     

     

     

     

    Error Description:

    An error occurred during report rendering.

     

    Error Details:

    An error occurred during report rendering.

     

    Full Stack:

    [ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

     

    [ReportServerException: Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)]

     

    [ReportServerException: An error has occurred during report processing. (rsProcessingAborted)]

       at Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e)

       at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)

       at Microsoft.Reporting.WebForms.ServerReport.SetDataSourceCredentials(IEnumerable`1 credentials)

       at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj)

     

    [CrmReportingException: An error occurred during report rendering.]

       at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj)

       at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters()

       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)

       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.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: 0x8004832C

    Source File: Not available

    Line Number: Not available

    Error Trace:

    Date: 10-11-2012

    Time: 16:16:42

    Server: crm

    Request URL: http://crm/thisismycompanynamerighthere/CRMReports/rsviewer/reportviewer.aspx 

  • Arto Kilponen Profile Picture
    Arto Kilponen 45 on at

    Trying to run Repair install, this is what I get:

     

    Any idea how to fix this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans