Microsoft Dynamics CRM UK Blog

CRM news and views from Simon Hutson

Dashboards Made Easy With Reporting Services

Dashboards Made Easy With Reporting Services

  • Comments 9

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

Attachment: Case Dashboard.rdl
Comments
  • Looks great Simon.

  • Hello

    You can guide my way upload "Case DashBoard.rdl" in Dynamic CRM 4.0 Dashboard

    And Upload "Case DashBoard.rdl" in Dynamic CRM 5.0 Dynamics CRM 5.0 is similar.

    Thanks

  • I'm not sure what you're asking, but if the question is "how can I upload my CRM 4.0 reports to CRM 2011 Online?", then the answer is "you can't". In order to provide a sandbox environment against malicious code (remember RDL is a fully fledged, T-SQL scripting language), we had to build a special CRM plug-in for reporting services to allow you to write FetchXML queries instead of T-SQL. This means we don't have to provide direct SQL server access over the Internet (a bad thing), but instead we expose the FetchXML query language via our secure Web Services. This blog post should get you started - blogs.msdn.com/.../how-to-creating-custom-report-with-microsoft-dynamics-crm-2011-bids-fetch-extension.aspx

  • I am intersted in realtime dynamic updating dashboards.  Can you help?

  • Hola, me podrías favor facilitar el script de la base de datos MicrosoftDynamicsCRM_MSCRM? Gracias de antemano por la ayuda.

  • Hi, could you pass me the database MicrosoftDynamicsCRM_MSCRM?

    Thanks in advance for the help.

  • Nsarmiento, It's been more than 2 years since I wrote this post. From memory, I think I am using the out-of-box data model so no specific database is required.

  • Simon,

    Where is the video tutorial on this?

  • Sam, it's here - blogs.msdn.com/.../video-dashboards-made-easy-with-reporting-services.aspx. You do know that CRM 2011 has all this out of the box, right?

Page 1 of 1 (9 items)
Leave a Comment
  • Please add 3 and 3 and type the answer here:
  • Post