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) / Convert SQL to Fetch XML
Microsoft Dynamics CRM (Archived)

Convert SQL to Fetch XML

(0) ShareShare
ReportReport
Posted on by stanch 120

How to convert the following query to fetch xml so that I can use in the reporting service report for the CRM data source

select '948150003' as ProvideCode, 'NL' as Province

union

select '948150004' as ProvideCode, 'NS' as Province

union

select '948150007' as ProvideCode, 'PE' as Province

Thanks

Stanley

*This post is locked for comments

I have the same question (0)
  • Karth Profile Picture
    Karth on at

    Have you explored this free online tool?

    http://www.sql2fetchxml.com/

    The tool converts a SQL Query to a FetchXML Query.

  • Community Member Profile Picture
    Community Member on at

    you can pass directly sql code to crm data source, fetchxml only fetch values from entities.

  • stanch Profile Picture
    stanch 120 on at

    have tried and got the Error: Object reference not set to an instance of an object.

  • stanch Profile Picture
    stanch 120 on at

    I have tried that but does not work. The CRM data source telling me it is not well xml format.

  • suresh maurya Profile Picture
    suresh maurya 630 on at

    For testing of FetchXML, you can test here online http://msxrmtools.com

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