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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM Online Re...
Microsoft Dynamics CRM (Archived)

Dynamics CRM Online Reports

(0) ShareShare
ReportReport
Posted on by Shaik Microsoft Employee

Hi All,

We are planning to move an existing On-Premise CRM instance (Service Management) to Online. Today we have huge data 3 Million Cases + 13 Million Emails, mainly our SSRS reports queries these two Entities. We see that current SSRS reports can't be converted to FetchXML reports because of its own limitations. Customer wants to move the system to Online, So what are the options here? Can't we really have SSRS reports in online? If not what are the best possible options for reports?

Let me know your design inputs.

Thanks,

Shaik

*This post is locked for comments

I have the same question (0)
  • Verified answer
    mscrmba Profile Picture
    mscrmba on at

    You can only do Fetch XML SSRS reports with Online.

    msdn.microsoft.com/.../gg328097.aspx

    You could possibly use T-SQL from a locally replicated reporting server

    blog.customereffective.com/.../microsoft-dynamics-crm-decision-matrix.html

    If you have reporting requirements that are beyond what can be done with Fetch XML.  Given your organization is online, then you might consider writing integration packages that replicate the CRM online data needed for reporting to a local SQL server instance and you can write SSRS reports locally using SQL queries. ScribeSoft has a product called Scribe Replication Services that can accomplish this, if you ever have a need to replicate CRM online data to local SQL server. You can also use SSIS to write packages that perform the replication.

    crmbook.powerobjects.com/.../advanced-reporting-options

    In this way the reports written locally can be accessed from CRM online reports area making it appear to the users that they are running the reports from CRM by hiding all the details behind the scene. This makes complex reporting possible even with CRM online.

  • Shaik Profile Picture
    Shaik Microsoft Employee on at

    Thanks Guido Preite, your suggestion was helpful.

    I definitely try out what fits best for our application, but just wondering for such a huge data eventhough I convert to FetchXML will the reports withstand for tomorrows data load. Is Power BI so matured to handle such huge amount of data? Any idea will be appreciated.

    Thanks,

    Shaik

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans