Search

Advertisements

SSRS - Multiple Sparklines chart

This article is about an example for creating multiple sparklines chart .

Step 1: Create Data source and then create Dataset with below query :

--Sample data
DECLARE @FY TABLE (Products VARCHAR(20),Q1 INT,Q2 INT,Q3 INT)
INSERT @FY SELECT 'SQLServer2008',1000,200,100
INSERT @FY SELECT 'SQLServer2012',1000,1000,1500
INSERT @FY SELECT 'SQLServer2014',1000,3000,5000
SELECT * FROM @FY



Step 2 :
Drag&drop Chart from Toolbox or right-click on report body - > Insert - > Chart .
Add a Line with Markers chart :




Step 3 :  Double - click on the chart area , you will notice Chart Data , Under Chart Data
for summation Values add Q1 , Q2 and Q3 columns from Dataset and then for Category Groups add Products column from the Dataset .



Click on Preview Pane :

No comments:

Advertisements