Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 294

4. After running the script, refresh the Northwind database and verify the table

is created. Run a SELECT statement shown here:
SELECT * FROM PrincetonTemp

Creating a report and inserting sparklines
Here, we will go through the steps to insert sparklines in our report.

1. Launch Report Builder to create a blank report.

2. Create a data source to connect to Northwind database on SQL Server 2012

KAILUA; use an embedded data connection, query type: text , Connection
string: Data Source=HODENTEKWIN7\\KAILUA , Initial Catalog= Northwind .

3. Create a dataset using the preceding data source and the following

query in the Query window:
Select * FROM PrincetonTemp

4. Create a report as shown in the following screenshot:

5. Insert a row below the second row called Outside Group - Below .

6. In the third row, third column place the cursor and from the Insert menu item,

click on the sparklines and click in the third row, third column.

7. In the Select Sparkline Type window displayed, choose Line | Stepped Line .

8. Similarly for the second column, third row insert a sparkline. Now the report

looks like the following screenshot:

The annotations and the background color were later added from the
Properties window.