O'Reilly logo

Microsoft Dynamics CRM API Development for Online and On-Premise Environments by Triston Arisawa, Mark Beckner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

  Reporting        Chapter 5 

This chapter outlines how to build SSRS reports that are hosted in CRM Online. CRM on-premise has a database, and SSRS reports can be built using standard SQL queries. CRM Online, however, does not have a database that is accessible to end users, and therefore all reporting must be done through the CRM API. Developing SQL Server Report Services (SSRS) reports using this API requires a shift in thinking around how best to solve reporting requirements that wouldn’t take a second thought when developing directly against SQL Server. This chapter will outline how to set up SSRS, how to connect to CRM Online, and how to build SSRS reports in order to query and display data from CRM Online.

SSRS Development Environment ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required