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 ...

Get Microsoft Dynamics CRM API Development for Online and On-Premise Environments now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.