Pro SQL Server 2012 Reporting Services

CHAPTER 5  IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS

expand the Emp_Svc_Cost_Sparkline dataset and drag the Visit_Count field on top of the new Sparkline.

If you hover over the Sparkline before releasing, you will see the Chart Data screen as you have seen in

earlier examples. Release the Visit_Count field into the Values section, as shown in Figure 5-21.

Figure 5-21. Sparkline: Chart data value

Upon previewing the report, you should see a daily trend of visits. It may seem a bit rough right

now, but we’ll make it a little nicer in a minute. You’ll also notice a parameter for MonthlyGoal that we

are about to implement as a variation of a key performance indicator or KPI. As we did in the Data Bar

example, we are going to change the color of our Sparkline to be a shade of Red or Green, depending on

whether we met our monthly goal of visits. Click the Design tab to make some more edits to our

Sparkline report.