Answered by:
Linking entities in crm

Question
-
I 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 Edgias Wednesday, May 2, 2012 10:45 AM
Wednesday, May 2, 2012 10:41 AM
Answers
-
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/ashishmahajanmscrmMy Linkedin: - Proposed as answer by Ashish Mahajan Technical Architect, Writer Wednesday, May 2, 2012 10:56 AM
- Marked as answer by Edgias Wednesday, May 2, 2012 12:13 PM
Wednesday, May 2, 2012 10:56 AM -
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/ashishmahajanmscrmMy Linkedin: - Proposed as answer by Ashish Mahajan Technical Architect, Writer Wednesday, May 2, 2012 12:02 PM
- Marked as answer by Edgias Thursday, May 10, 2012 8:40 AM
Wednesday, May 2, 2012 12:02 PM
All replies
-
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/ashishmahajanmscrmMy Linkedin: - Proposed as answer by Ashish Mahajan Technical Architect, Writer Wednesday, May 2, 2012 10:56 AM
- Marked as answer by Edgias Wednesday, May 2, 2012 12:13 PM
Wednesday, May 2, 2012 10:56 AM -
thanx for your response but in addition i want to link the account entity(need this for customer's contact details)Wednesday, May 2, 2012 12:00 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/ashishmahajanmscrmMy Linkedin: - Proposed as answer by Ashish Mahajan Technical Architect, Writer Wednesday, May 2, 2012 12:02 PM
- Marked as answer by Edgias Thursday, May 10, 2012 8:40 AM
Wednesday, May 2, 2012 12:02 PM