CRM Online: Reporting Options


Microsoft Dynamics CRM Online is a fantastic CRM platform for most small medium businesses (SMB) – it is so easy and inexpensive to get started. 

However, one area of challenge for Microsoft CRM Online is custom reporting.  Some background on this.  Unlike Microsoft CRM On-Premise, Microsoft CRM Online does not support uploading of SQL Report Services (SRS) custom reports (.RDL) or accessing the SQL Server Database filtered views.  CRM Online does not allow users to directly access the CRM Application Server or Database Server – this is a good thing to maintain security and the 99.9% uptime for all the companies that are running on Microsoft CRM Online.  In fact, I’m not aware of any other major On-Demand Business Application vendors allowing their users to directly access the application or database server.

After working on numerous Microsoft CRM Online deployments, here is what I would suggest as a good practice for reporting:

Start with the "Out of the Box" options such as Default Reports, Charts, Advanced Find / Export to Excel, Mail Merge, and Report Wizard to meet your CRM Online reporting needs.  If none of them are "good enough" then go with custom report development (SDK).

Here are some good references/links to the reporting options mentioned above:

Default Reports:
To view the list of default reports that come with Microsoft CRM Online –
from the CRM Client >> Workplace >> Reports

Advanced Find / Export to Excel:
Blog:
http://blogs.msdn.com/crm/archive/2008/12/29/poor-man-s-business-intelligence-for-microsoft-dynamics-crm.aspx

Video: Using Advanced Find – Time: 10:02 minutes
This video will show you how to use the Advanced Find feature to find and take action on targeted sets of data. It will also show how to create Saved Views (My Views).
http://www.democrmonline.com/AdvancedFind/

Mail Merge:
Blog: MSCRM 4.0 Mail Merge Basics
http://blogs.msdn.com/crm/archive/2008/01/15/mscrm-4-0-mail-merge-basics.aspx

Blog: Microsoft Dynamics CRM Mail Merge Templates
http://blogs.msdn.com/crm/archive/2008/06/10/microsoft-dynamics-crm-mail-merge-templates.aspx

Blog: Printing Quote for customer
http://blogs.msdn.com/crm/archive/2008/03/12/printing-quote-for-customer.aspx

Video: Mail Merge – Time: 08:03 minutes
This video will show how to create mail merge templates and create emails and Word labels with mail merge.
http://www.democrmonline.com/MailMerge/

Report Wizard:
Blog:
http://blogs.msdn.com/dynamicscrmonline/archive/2009/02/16/report-your-lost-opportunities-to-competitors.aspx

Video: Reporting Overview – Time: 15:29 minutes
This video will show the reporting capabilities in Microsoft Dynamics CRM Online.
http://www.democrmonline.com/reporting/

Export and Integrate CRM Data to a Local Data Source (Access, SQL Server, SQL Server Express, etc.):
There are two approaches for this.  Please note that the two approaches are not supported by Microsoft CRM Support – use at your own risk/support.

1. Subscribe to the Microsoft CRM Online Professional Plus edition that supports the Offline Data Synchronization feature.  Setup a Microsoft CRM Online Outlook Client and ensure that all the needed CRM Online data are continuously updated to the local database.  Then use the Microsoft SQL Server Reporting Service (SRS) report development tool or other reporting, Business Intelligence (BI) tools to build the custom report against the local SQL Server Express CRM database used by the Microsoft CRM Online Professional Plus edition.  Note: 4 GB database limit for SQL Server Express

2. Utilize an integration tool to extract CRM data to a local data source and then use a corresponding reporting tool.  For example, you can purchase and setup the Scribe Software Insight to integrate between Microsoft CRM Online and the local SQL Server database.  The local SQL Server database will mimic the needed CRM Online tables so  you can use the Microsoft SQL Server Reporting Service (SRS) report development tool or other reporting, Business Intelligence (BI) tools tools to build the custom report against the local data


Custom Development (SDK):
With Custom Development (SDK), the reporting options are endless.  Link to the Microsoft CRM SDK: http://msdn.microsoft.com/en-us/library/bb928212.aspx

Here is a link to a good article by Jon White of Microsoft CRM Online team on Using Microsoft SQL Reporting Services with Microsoft CRM Online


Here is a link to our FREE Web-based utility – Workopia CRM User Performance Report Online.  It was built by one of our developers using Microsoft CRM SDK that produces a user or team’s performance report.  Compare performance this week vs. last; this quarter vs. last and much more…  It reports the break down for the different record states, Lead count from different Lead Sources and the count of Opportunity records originated from a Lead record.   Enjoy.
http://www.workopia.com/CRMReportOnlineRegistration

Here’s a case study regarding custom report development for Microsoft CRM Online:

One of our Microsoft CRM Online clients in the high tech engineering services industry had a need for several reports, some of those reports are used as "summary printouts" to be given to the customer upon service completion.  These reports contain very specific formatting, layout, calculations, graphics, and data content from various Microsoft CRM related areas, more than two levels of data relationships.

We had tried to use the "Out of the Box" options to see if it is "good enough", but none of them were acceptable for this case.  The Client loves Microsoft CRM Online but without their critical reports, they will have to either switch to Microsoft CRM On-Premise or to another CRM system.

We decided to build their Microsoft CRM Online reports via custom report development – this worked great!   The Client can now click on a report button from either their CRM Online Web Client or Outlook Client to access these custom reports.  The Client got the EXACT reports they are looking for and was able to stay with Microsoft CRM Online without switching to another CRM system.  The effort to build these custom reports was about the same as if we have to build them via SRS custom report development for an On-Premise environment.

In summary, if you have data in Microsoft CRM Online that you would like to report on, and none of the "Out of the Box" reporting options are good enough, then try custom report development.

 

 
Contact us if you need help with your Microsoft CRM.  Free Estimate.
 
Frank
Workopia, Inc.
Microsoft Dynamics CRM MVP

Follow Workopia on Twitter

FREE 30-Day Trial, Setup & Training – Microsoft CRM Online
 Sign up for a FREE 30-Day Trial, Setup & Training

Advertisements

About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
This entry was posted in CRM Online. Bookmark the permalink.

2 Responses to CRM Online: Reporting Options

  1. Michael says:

    How exactly did you do custom report development using the SDK? Did you use JScript?Michael Cross

  2. Frank says:

    I\’d checked with the developer, JScript was not used. I don\’t know the engineering/coding details but they\’d used Microsoft Visual Studio and referenced the Microsoft CRM SDK to build it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s