sql-based reports for CRM Online

All replies

• 

  

  0

  Sign in to vote

  Hi Benjamin,
  it is not possible to create SQL-based reports for CRM Online, you must use FetchXml.

  ---

  My blog: www.crmanswers.net - Rockstar 365 Profile

  • Proposed as answer by Guido PreiteMVP Friday, December 6, 2013 3:36 PM
  • Unproposed as answer by Benni_1983 Wednesday, December 11, 2013 1:38 PM

  Friday, December 6, 2013 3:36 PM
• 

  

  0

  Sign in to vote

  any hack? 3rd Party supplier? Special idea?

  Friday, December 6, 2013 4:10 PM
• 

  

  0

  Sign in to vote

  You could sync your data down to a a local SQL Server and do the reporting there

  ---

  Jason Lattimer
  My Blog -  Follow me on Twitter -  LinkedIn

  • Proposed as answer by JLattimerMVP, Moderator Friday, December 6, 2013 5:00 PM

  Friday, December 6, 2013 5:00 PM

  Moderator
• 

  

  0

  Sign in to vote

  this is how I am doing right now - the Problem here is that it is not in live-time - and the reports are only actual if sync was done before ;-)

  other ideas?

  Tuesday, December 10, 2013 6:44 AM
• 

  

  0

  Sign in to vote

  Hi,

  Why don't you use FetchXml instead? any reason?

  Refer below blog for FetchXml based reports.

  https://social.technet.microsoft.com/wiki/contents/articles/10234.microsoft-dynamics-crm-2011-develop-fetch-xml-based-ssrs-reports-in-visual-studio-2008.aspx

  http://www.stoneridgesoftware.com/crm-online-reporting-with-fetchxml-intro/

  Thanks!

  Tuesday, December 10, 2013 7:15 AM
• 

  

  0

  Sign in to vote

  because you cannot create complex reports using fetchXml. This is why I ask here for tipps.

  I know how to use fetchXml ;-)
  
  Regards

  Tuesday, December 10, 2013 7:21 AM