You’re offline. This is a read only version of the page.
I need to transfer a CRM 4.0 "project" to CRM 365. I have already transferred the data and create all forms. The main "program" in 4.0 is a .dll plugin involve few sql in it, each sql includes multiple "group by", "join". There is an update sql query as well. The .dll includes a complicated customized "view" from sql server. Then this .dll would call a report rdl, in the rdl there are more sql and call a stored procedure. Finally a report would be generated.
I need to do this fast so plan to do all of these in a asp.net program. I think I can either use queryexpression or FetchXML. But look like queryexpression doesn't support "group by" that kind of aggregate functions so it looks like FetchXML is easier. But FetchXML seem like has no debug at all.
Any suggestion? Thanks.
*This post is locked for comments
I have the same question (0)Hi,
If you have Group By in your queries- go for FetchXML. You can test your queries here- http://msxrmtools.com/fetchxml
You may also download XrmToolbox which has FetchXML tester plugin
Share
Report
All responses (
Answers (
4
