Dynamics CRM Report - Generate SSRS report using CRM DB and Extension Database

1) Create 2 data sources
a)DNSCRM_EXT (connect ext database, not using filtered table)

b)MSCRM_DataSource (connect CRM database, using filtered table)

Dynamics CRM Using SQL Server Reporting Services

Dynamics CRM uses the Reporting Services reports that is the Report Definition Language (RDL)
Report entity contains standard security settings like other entities.

2 Report permissions - Publish Reports, Add Reporting Services Reports.

Run reports in one of 3 areas - Reports View (Workplace -> My Work -> Reports subarea), Entity Ribbon, Entity Form

CRM Report Wizard

The following table compares the features of charts and dashboards with those of the SQL Server Reporting Services Report Wizard.

	Charts and Dashboards	SQL Server Reporting Services Report Wizard
Report output	Inline visualizations  presented within Microsoft Dynamics CRM grids and forms	Web-based reports that can be exported to additional formats, such as Microsoft Excel, PDF, and CS
Ability to schedule reports for email delivery	No	Yes
Ability to include data from multiple record types in results	No	Yes
Ability to prompt users to enter parameters before running reports	No	Yes

CRM includes 25 standard SQL Server Reporting Services reports in the base product.