I know how to create the report using ADVANCED FIND but I want to create a Custom Report in CRM online using fetchxml.
Asked
Active
Viewed 86 times
2 Answers
3
A good way to get up and running with FetchXML is to use the FetchXML Builder tool in XrmToolBox.
XrmToolBox can be downloaded from www.xrmtoolbox.com and the FetchXML Builder is installed from the Plugins Store inside XrmToolBox.
More information on FetchXML Builder can be found on fxb.xrmtoolbox.com and a tutorial on how to create advanced views with it in this article on MSDynamicsWorld.com.
Jonas Rapp
- 514
- 2
- 9
0
Here you go: This post will teach you many things like Getting FetchXML from Advanced Find query & customize it, build a report from scratch, design it, etc.
Try to learn Some SQL stuffs & CRM videos which will help you.
For SQL to fetchxml query converter use: http://www.sql2fetchxml.com/
Arun Vinoth-Precog Tech - MVP
- 22,364
- 14
- 59
- 168
-
so first step is to learn SQL and create query later convert it into FetchXML. Right? Either SQL or Fetch XML any one of this is enough no? – akshay pattar Jun 06 '17 at 12:42
-
yes, SQL is always a mandate for Developer.. SQL is good for on-premise, whereas Fetchxml is mandatory for CRMonline reports (as SQL server is inaccessible) – Arun Vinoth-Precog Tech - MVP Jun 06 '17 at 14:35
-
1sorry i forgot to mention that, im using ONLINE, not on-premises and i dont know Fetch XML, is it okay to write whole query in sql and convert it into the FetchXML.? – akshay pattar Jun 06 '17 at 18:29
-
upto you, like Jonas mentioned in another answer - you can build fetchxml also using tool.. – Arun Vinoth-Precog Tech - MVP Jun 06 '17 at 19:15