Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS Reports in D365 O...
Microsoft Dynamics CRM (Archived)

SSRS Reports in D365 Online

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are in process of upgrading  from On-premise to D 365 online and have few complex SQL Reports/Queries which cannot be converted to FetchXML.

I have gone through few blogs and got to know about replication of CRM online data to Azure database and SQL reports can use Azure DB as a data source which can then be deployed to CRM online reports area and thus making complex reports even  possible in D 365 Online.

I am working on a POC on this approach and have got an error while creating a SQL report as shown below

4152.error1.png

Could you please help me on the data source connection or how the complex SQL report will work in D365 online.

Thanks in Advance!

*This post is locked for comments

  • Suggested answer
    sandeepstw Profile Picture
    sandeepstw 4,601 on at
    RE: SSRS Reports in D365 Online

    Hi,

    You can do using data exchange service. Kind review this link -

    blogs.msdn.microsoft.com/.../introduction-to-dynamics-365-data-export-service

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: SSRS Reports in D365 Online

    Hello,

    To be honest I have never done that before but it sounds possible to implement something similar to FilteredView approach that is used in on-prem reporting.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Reports in D365 Online

    Hi Andrew

    Thanks for the suggestion. It worked well.

    How does Security work here. As CRM reports run on FilteredViews, Can we replicate the FilteredViews as well? Will this be the same as On-Premise execution?

    Regards

    Sneha

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: SSRS Reports in D365 Online

    Hello,

    If you want your report to work with external you will have to publish it somewhere outside of CRM and create a report using "Report type" as "Link to webpage" option.

    Good luck.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans