Microsoft Dynamics CRM Team Blog: CRM 2011 Charts – Know the Real Potential ~ Part I

[Blog bot]

Источник: http://blogs.msdn.com/b/crm/archive/...al-part-i.aspx
==============

Microsoft Dynamics CRM 2011 brings to you extensive charting and dashboard capabilities, helping the users to analyze their data quickly and effectively.

In this blog series I will be discussing the enriched chart features which will help you create the complex business charts to gain real time insights.

Before diving deeper into the CRM charting potential we need to first understand some key charting concepts and terms which I will be referring in the blog going forward:

The Chart components - The chart control is rendered as a single image. A chart can contain one or more series where each series is a collection of the data points.

For instance, in the chart to the right you have two series- Estimated Revenue, Actual Revenue and one category – Potential customer:

First series has chart type column and the second one is configured as a line. Thus to have multiple lines in the chart, you would define one series for each line.

The chart designer allows you to create only single series chart with one category. But through import and export feature, you can customize your chart definitions and create any complex chart – personal or system if you have the required privileges.

To understand the chart definition better let’s look at the exported Xml of an OOB chart.

1. Navigate to the Accounts entity

2. Click the collapsed chart pane .Select the chart Accounts by Industry.

3. Click on the Charts tab in ribbon.

4. Click export Chart.

You will get a XML like this:





A chart is defined using two important aspects – data and appearance. The XML subpart highlighted Yellow is the DataDescription for the chart which defines the underlying data used to render chart.

The other subpart highlighted Green is called as the Presentation Description for the chart which defines the presentational aspects (chart type, color, legends) of the chart.

The CRM 2011 business charts leverages the Asp .Net Chart Controls (available in .Net 3.5 >) and hence the presentation description is exactly similar to the .net chart controls serialized xml.

To understand it better let’s try adding a new dimension to the above chart J . Yes, you heard it right the 3D charts are available in CRM 2011 –

Add the Area3DStyle node under ChartArea in the exported xml:

  

     

You might have caught the hint that CRM charts have all the capabilities that asp .net chart controls possess. You just need to tweak the xml and import it back!!

Time to explore the wide array of charting features! Here are some business users’ requirements and we can achieve these and many more using CRM charts-

1. Multi Series Charts - I want to compare the revenue earned with the discount provided.

2. The Stacked, Pyramid charts look cool .Can I create such charts?

3. Comparison Charts or Multi category- How can I compare my company's sales for 2010 with sales for the year 2009

4. Large differences in data ranges and the chart looks ugly – do charts support a scale break?

5. Can I customize the series name?

To help with you an example let’s try to create a multi series chart -Estimated revenue v/s Actual revenue

1. Navigate to Opportunities.

2. Click Charts tab in ribbon.

3. Click New Chart.

4. Select Estimated Revenue as Series, Sum as the aggregate.

5. Select Potential Customer as Category.

6. Save and Close.

At this point you have created a single series chart which depicts Estimated Revenue for each Potential Customer.



7. Now Click Export and save the Xml. You will get the exported Xml like:

<div style="padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px" id="scid:9D7513F9-C04C-4721-824A-2B34F0212519:eceb887c-566e-4e74-a08a-aa40e99afc10" class="wlWriterSmartContent">{A3A9EE47-5093-DE11-97D4-00155DA3B01E}Sum(Estimated Revenue) by OwnerShows the estimated revenue by owner.opportunityfalse