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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.