Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 5  IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS

Listing 5-7 shows a consolidated section of the RDL file for the Indicator report item.

Listing 5-7. RDL Indicator




=Sum(Fields!Diff.Value)
1
NoOutput

None
Tablix1
...




1


-1
1

Red
0.99
ArrowDown

External




...

...


The completed report for the Indicator is called Indicator.rdl in the Pro_SSRS solution.

Summary

In this chapter, we covered some of the more visually appealing objects in Reporting Services, such as
charting, maps, and gauges. Most of these objects are typically found in dashboard style reporting to
provide an at-a-glance perspective. We also went over the chart data region and walked through
examples of the different chart types available. Now that you’re more comfortable with the design
environment, you’ll learn how to use it to design and deploy some real reports. In the next chapter, we’ll
show how to take a step-by-step approach to adding these report items to a report that was designed as
part of an SSRS migration for a health care application.

Free download pdf