Dashboards Made Easy With Reporting Services

All Over The World…

I don’t know about you, but I have always struggled with our dashboard story in CRM 4.0. It’s not that we don’t have plenty of dashboard capabilities, with solutions such as the Analytics Accelerator that we provide free of charge as well as various 3rd-party solutions (Axonom Powertrak etc.), it’s just that it takes more time than it should and requires a higher level of technical skill in the underlying technologies such as Microsoft PerformancePoint Server.

The next version of CRM (codename CRM “5”) will have out-of-the-box charting and dashboard capabilities, as shown by Girish Raja during the PDC 2009 session entitled Managing the Solution Lifecycle for xRM Applications (see picture below), but how can we make dashboards simple for CRM 4.0 today?

CRM "5" Dashboard

A couple of months ago I spent some time getting to grips with SQL Server 2008 Reporting Services, and the new chart and gauge controls that are now available. Using Visual Studio 2008 and the Business Intelligence Project add-ins that come with SQL Server 2008, I was able to build a multi-chart report, and within a couple of hours I had a pretty good looking dashboard. With a little extra work, I was able to modify the CRM SiteMap configuration file to include this report in the CRM UI and set it as the default home page. The screenshot below shows a “Case Management” dashboard, but I have re-purposed the same report for several different client demos. All I had to do was change the underlying report queries to point to different CRM entities and attributes and voila.! Instant “Leads Management” or “Campaign Management” dashboards.

Case Dashboard

I’m in the process of recording a short “instructional” video showing how to build this dashboard for scratch, and I will post this as soon as it’s ready. In the meantime, I’ve attached the reporting services .rdl file that you can import into CRM and start using straight away here.

This posting is provided "AS IS" with no warranties, and confers no rights.

Laughing Boy Chestnuts Pre-School

Case Dashboard.rdl