Simple Doughnut Chart for Analysis Services Data
Overview
As we observed in Introducing Reporting Services Charts for Analysis Services, Reporting Services enables us to present both summarized and detailed data in colorful, easy-to-read charts of various designs, from which we can chose the layout and type that best meets any given business requirement. Among the types offered, the Doughnut chart is, in general, somewhat less popular than other chart types, such as the Pie chart, yet it is often selected in scenarios where the characteristics of a Pie chart can be had with some variety. In this article, we will introduce the Simple Doughnut chart type and get some hands-on exposure to its creation and its general characteristics. This will serve as a basis for other, more in-depth, practical exercises in coming articles, where we will extend the value of our chart-enhanced reports in myriad ways. Among these ways, just for starters, are the capability to format chart and other objects within a host of options, to drill down to see the details behind the graphical / numerical summaries, to combine chart reports with other types of reports, and to access many other options in the powerful Reporting Services tool set.
My objective within this article is to assist the reader in quickly assembling a report containing a working Simple Doughnut chart (relying upon, for instance, already assembled datasets and other underlying support within an existing sample report), and to move efficiently into targeted reporting nuances that meet real world needs. While this initial introduction will focus more on the creation of a Simple Doughnut chart, the report we create will serve as a basis, in prospective articles, to demonstrate more detailed intricacies that I have found useful in meeting business requirements of my own clients and readers. The ultimate objective, as is typically the case within my various series, is to provide hands-on opportunities to learn overall, start-to-finish procedures, before homing in on specific options of interest (although we will certainly deal with many of these options in even our early exercises, as a part of completing the stated objectives of these sessions).
Tags: ssrs