Advertisement

Reporting

  • Mark Beckner
  • Triston Arisawa
Chapter
  • 681 Downloads

Abstract

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.

Keywords

SQL Server Reporting Services (SSRS) SSRS Reports Business Intelligence Development Studio (BIDS) Report Data Window Folding Parameters 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Mark Beckner 2013

Authors and Affiliations

  • Mark Beckner
    • 1
  • Triston Arisawa
    • 1
  1. 1.COUS

Personalised recommendations