A customer has a CRM4 installation, and don’t want to upgrade to CRM 2011 just yet, but he wants to be able to create some dashboard with important KPIs. Our CRM expert found a nice video on how to create such dahsboard in CRM through SQL Server 2008 Reporting Services and Visual Studio. The video is located at channel9.
This video describes the following steps:
- Create the placeholder for the report in CRM4
- Export the report IDL file
- Create a new SQL Server 2008 report based on this IDL file
- Update th ereport within CRM4 again
The result is given in the screenshot below: