I need to insert a sparkline based on values in columns. After much searching and attempts I am stumped.

Sorry I cannot insert a image - seems my account must be verified (whatever that means).

Basically what I need is a sparkline that is created based on columns for each row. Like in Excel.

I have seen a similiar question here (https://social.technet.microsoft.com/Forums/sqlserver/en-US/02088214-39f2-4fbd-9f03-15aa6da20b9d/adding-a-sparkline-based-on-multiple-columns?forum=sqlreportingservices). However the answer seems cumbersome and is above me.

Surely there must be a solution to what seems a simple application? I must be missing something as I am new to Report Builder 3.0.

Appreciating any feedback.

Hi GideonE,

have you had a look at this Video ?

Cheers

Martin

Hi,

"However the answer seems cumbersome and is above me". You have to do it that way :) There is no other way. SSRS doesnt treat columns like Excel does. You have to use unpivot SQL function which is easy if your source is SQL Server. If you want to help with SQL you can post it below or in T-SQL forum.

• Edited by Steelleg4 19 hours 38 minutes ago

Hi,

"However the answer seems cumbersome and is above me". You have to do it that way :) There is no other way. SSRS doesnt treat columns like Excel does. You have to use unpivot SQL function which is easy if your source is SQL Server. If you want to help with SQL you can post it below or in T-SQL forum.

• Edited by Steelleg4 Wednesday, August 19, 2015 11:30 AM

Thank you Martin for taking the time to answer me.

Yes I have. My challenge is that I need a sparkline on each individual row, without summarizing the columns. The video does not address

my  "basic" and "logical" perception of sparklines.

I am still hoping for a clearer answer to this.

Thank you Steelleg4 for your time and effort to help a newbie.

I am trying to use report builder in a visual basic application using SQL Express 2014 and

Visual Studio Express (cheap skate that I am - exchange rates in the Dark Continent !).

How  do I use the UNPIVOD-ed-table ( temporary table) in reportbuider 3.0?

How do I "call" this in Report Builder 3.0?

Do I do this is SQL or Report Builder 3.0 ?

Once again thank you for your patienc and time.

Kind Regards

Hi GideonE,

In Reporting Services, we cannot add a sparkline to a detail group in a table. Because sparklines display aggregated data, they must go in a cell associated with a group. So in your scenario, if the database store the records like that:

You can directly use those records in dataset, then add a sparkline.

If the data stored in database looks like below:

When you create a dataset, you need to write a query in query designer with unpivot operator, so that you can return [Employee],[Date] and [Amount] columns then add those three fields to a Tablix to create corresponding sparklines.

Reference:
Sparklines and Data Bars (Report Builder and SSRS)

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Hi Qiuyun

Thanks for your reply. I am still not getting it.

My data looks like the second set. I need a sparkline for the last five columns.

My query in Report Builder looks like below. I am not getting those column names with the query.

SELECT plaasnaam, blokno,ton
FROM
(
  SELECT plaasnaam, blokno,ton_min5, ton_min4, ton_min3,ton_min2,ton_min1
  FROM dbo.oesskat5j
) AS cp
UNPIVOT
(
  ton FOR oesjare IN (ton_min5, ton_min4, ton_min3,ton_min2,ton_min1)
) AS up;

My query seems to be the problem. Hope you can help.

Hi Qiuyun

Thanks for your reply. I am still not getting it.

My data looks like the second set. I need a sparkline for the last five columns.

My query in Report Builder looks like below. I am not getting those column names with the query.

SELECT plaasnaam, blokno,ton
FROM
(
  SELECT plaasnaam, blokno,ton_min5, ton_min4, ton_min3,ton_min2,ton_min1
  FROM dbo.oesskat5j
) AS cp
UNPIVOT
(
  ton FOR oesjare IN (ton_min5, ton_min4, ton_min3,ton_min2,ton_min1)
) AS up;

My query seems to be the problem. Hope you can help.

Hi,

you are missing just "oesjare" in your select

SELECT plaasnaam, blokno,ton,oesjare
FROM(
	SELECT plaasnaam, blokno,ton_min5, ton_min4, ton_min3,ton_min2,ton_min1 
	FROM dbo.oesskat5j) AS cp
UNPIVOT (
	ton FOR oesjare IN (ton_min5, ton_min4, ton_min3,ton_min2,ton_min1)) AS up;