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

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) / Dynamics 365 Online SS...
Microsoft Dynamics CRM (Archived)

Dynamics 365 Online SSRS Report Deploy

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

We are currently using Dynamics 365 online and are using Visual Studio 2012 to create reports and import them back into Dynamics.

We are trying to deploy these reports to SSRS with the view to using a scheduler to email them out.

We can successfully use and view data from CRM in Visual Studio using CRM fetch. The report successfully deploys to SSRS but when we run it in the web browser we get the following error:

An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)
We are confused why the reports would run in VS 2012 using the CRM Fetch but not on SSRS. We have checked the rsreportserver.config and added the MSCRMFETCH extension.

Can anyone help?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    ashlega Profile Picture
    ashlega 34,477 on at

    Hi Colin,

     in the Visual Studio, you have installed report authoring extensions.

     There are, also, extensions that need to be installed on the SSRS server, but it only works with on-prem CRM:

    technet.microsoft.com/.../hh699807.aspx

     (so that's to answer "why".. but there is no workaround - you can't use your own SSRS server with the online version)

  • Community Member Profile Picture
    Community Member on at

    Thanks Alex, appreciate your quick response.

    Do you know of any other way i can schedule a weekly email with a CRM report/views attached?

    Colin

  • ashlega Profile Picture
    ashlega 34,477 on at

    Not really. One workaround might be to set up a local reporting database and a nightly job to bring data to that database (using SSIS, for example). Then you can run SQL reports off that data on your SSRS server (and, so, you can schedule them etc).

    You can, possibly, use third-party products(such as XPeriDo, for instance), to generate documents/pdf files in the workflows. Those are not SSRS reports, though.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Colin

    I would take a look at XperiDo from Invenso (although they have just been purchased by XpertDocs).  You can send out automated emails using XperiDo service and trigger these or via a workflow assembly which they also provide.  Of course it's a paid for service.

    Thanks

    Phil

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans