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 :
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:
Post a Comment