Linking entities in crm
-
Wednesday, May 02, 2012 10:41 AMI am developing reports in Dynamics CRM 2011 using BIDS and fetchxml. I want to link the (order products) entity to the (order) entity. The unit price and quantity are found on the {order products} and need to link them to the other details on the {order}. Any help will be appreciated.
- Edited by chirochino Wednesday, May 02, 2012 10:45 AM
All Replies
-
Wednesday, May 02, 2012 10:56 AM
Hi,
Try the advanced find. Open the advanced find, and select order products entity. Then go to edit columns and add the order and order products fields. Then go to Download Fetch XML and that will give you he fetch XML. You can open that downloaded file in notepad and get the Fetch XML.
Read my blog on Fetch XML based reports: http://ashishmahajancrm.blogspot.com.au/2012/04/microsoft-dynamics-crm-2011-develop.html
Also find 2 screen shots for your help:
I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: 
- Proposed As Answer by Ashish Mahajan Australia (Architect) Wednesday, May 02, 2012 10:56 AM
- Marked As Answer by chirochino Wednesday, May 02, 2012 12:13 PM
-
Wednesday, May 02, 2012 12:00 PMthanx for your response but in addition i want to link the account entity(need this for customer's contact details)
-
Wednesday, May 02, 2012 12:02 PM
Hi,
If there is a relationship, then you should be able to see the options the way I mentioned above.
I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: - Proposed As Answer by Ashish Mahajan Australia (Architect) Wednesday, May 02, 2012 12:02 PM
- Marked As Answer by chirochino Thursday, May 10, 2012 8:40 AM
