1254
Part IX: Business Intelligence
represents one or more data points of the row, with each data point using one bar or
column. It can be the literal value of a fi eld, or the databar can indicate the result of an
expression.To provide the cell for one of these new chart types, select the furthermost right column
handle in a report. Right-click and select Insert Column ➪ Right. To insert a databar,
right-click the newly created text box, and select Insert ➪ Databar. The Select Databar Type
dialog box appears where a databar or column can be selected. After the type is selected,
you can confi gure the chart with data by double-clicking the bar in the Design view. You
can add Data fi elds from the dataset to the Values by clicking the green plus sign, as shown
in Figure 55-9.FIGURE 55-9
Adding fi elds to values in a Databar.Another mini-chart, available since SSRS 2008 R2, is the Indicator. Indicators work by
visualizing a value in a dataset as compared to a range of values. For instance, Figure 55-10
shows an Indicator setup that assesses the annual sales for the Adventureworks clients and
breaks them evenly into three categories by percentage of sales. The bottom third is shown
with the red diamond, midrange clients receive the yellow triangle, and the high sales
clients achieve the green dot.Sparklines are mini-charts which can represent multiple values for a line of a report.
They differ from Databars and Indicators in that they can represent more than one
value on the row. For instance, a client’s sales over time can be represented on one line
of a report, and a Sparkline can be applied at the end of the line to show the trending
line chart of the sales values. Sparklines give instant visual representation of the data
and the ability to quickly compare rows. As shown in Figure 55-11, they provide instant
trending information.c55.indd 1254c55.indd 1254 7/31/2012 10:28:07 AM7/31/2012 10:28:07 AM
http://www.it-ebooks.info