Linking entities in crm
-
2. května 2012 10:41I 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.
- Upravený chirochino 2. května 2012 10:45
Všechny reakce
-
2. května 2012 10:56
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: 
- Navržen jako odpověď Ashish Mahajan Australia (Architect) 2. května 2012 10:56
- Označen jako odpověď chirochino 2. května 2012 12:13
-
2. května 2012 12:00thanx for your response but in addition i want to link the account entity(need this for customer's contact details)
-
2. května 2012 12:02
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: - Navržen jako odpověď Ashish Mahajan Australia (Architect) 2. května 2012 12:02
- Označen jako odpověď chirochino 10. května 2012 8:40
