Microsoft SQL Server 2008 R2 Unleashed- P225:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2204 CHAPTER 53 SQL Server 2008 Reporting Services TABLE Reporting Services Controls Summary Control Data-Bound Purpose Notes Subreport No Displays another report on a report parameters passed to a subreport enable drill-through that is from one report to the next uses subreports to chunk reports into reusable blocks. Allows your current dataset to supply values to a subreport as parameters. Text Box No Displays textual data supports internationalization. Each Tablix data region cell contains a single text box by default. Using the Data Visualization Controls Sparkline Indicator and Data Bar In the next few examples we examine the new controls that come with SSRS 2008 R2 starting with Sparklines. As mentioned earlier a Sparkline is a small easy-to-understand chart that you usually place inside the text box cell of a grouping row in a Tablix. Sparklines make it easy to see trends in data at a glance. Most types of Sparklines can be converted to full chart controls when necessary except for 3D charts . In the following example we add a Sparkline to a new report. As you ve done before right-click your Reports folder in Solution Explorer and then click Add New Report. As you follow the steps of the Report Wizard select your shared data source pointing to the AdventureWorks2008R2 database and then enter the T-SQL shown in Listing for your report query. LISTING T-SQL Code for a Sparkline Report SELECT FROM h JOIN e ON JOIN p ON ORDER BY This query illustrates changes in hourly pay rates for all employees over their entire term with the company. Developing Reports 2205 Continuing with the Report Wizard choose the Tabular report style and then add all the columns generated by the query to the detail area of the .
