Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Fetch Xml and SSRS Rep...
Customer experience | Sales, Customer Insights,...
Suggested answer

Fetch Xml and SSRS Reports

(0) ShareShare
ReportReport
Posted on by krishna 30

Hi,

i have a doubt regarding reports. When to use FetchXml reports and When to use SSRS reports..?

Regards,

Chaitanya

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Fetch Xml and SSRS Reports

    As per the previous post, there are 2 decisions:

    1. Whether to use the Reports Builder to create the reports, or whether to use Visual Studio. If you can create the report you want using Report Builder, then do so, but for more complex reports I'd use Visual Studio
    2. If using Visual Studio, whether to use FetchXML or SQL-based. This choice is only available for OnPremise. Again, the report complexity could be a factor. If you can use FetchXML, then I'd do that, but there are some queries that you can only do in SQL 
  • Suggested answer
    Siddique mahsud Profile Picture
    Siddique mahsud 11 on at
    RE: Fetch Xml and SSRS Reports

    There are two types of reports:

    1. Reports builder using wizard within dynamics CRM (FetchXml based)
    2. Custom Reports (SSRS Reports )
       a. FetchXml based (supported in online & on-premise CRM)
       b. SQL Based (supported in on-premise CRM only)

    If you have online CRM then you have only one option to create FetchXml based reports.

    If you have On-premise CRM then you have both options SQL Based and FetchXml based reports, I would prefer to use fetchXml instead of SQL based in case you are planning to go online in the future.

    Further, you can see the following links:

    gonzaloruizcrm.blogspot.com/.../sql-vs-fetchxml-reports-in-crm-2011.html

    community.dynamics.com/.../426840

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans