What have you tried so far to achieve your result?

If you have to do it with an expression, this should work:
SUBSTRING( @[User::XML], FINDSTRING( @[User::XML],"<double>", 1) + 8, FINDSTRING( @[User::XML],"</double>", 1) - (FINDSTRING( @[User::XML],"<double>", 1) + 8))
Where...

This is totally dependant on your data, but as we have such a small sample, then who knows. As John said though, you're better off doing it in a presentation...

let's start off by making that into something usable for other members of the community. Have a read of the link in my signature, however, I've done it for you...

How are you getting the value from your table. Could you not instead retreive the value straight from your SQL table? For example:
CREATE TABLE #Sample (ID INT...

Do all the tables have an identical structure? Doing a UNION removes all duplicates from a dataset so...
INSERT INTO MainTable
SELECT *
FROM Table1
UNION
SELECT *

IF both tables have identical DDL, AND you're not using an IDENTITY Column, you could simply do:
INSERT INTO dbo.emp
SELECT *
FROM dbo.emptemp et
WHERE et.empid...

Yep, that's the problem! 🙂 As January doesn't exist for that row, it isn't displayed in the chart.

You'll need to use some kind of Date or reference table....

If you were to run the query in SSMS, would a row actually be returned for say, January for that specific description?

Simply doing:
SELECT *
FROM emptemp et
WHERE et.empid NOT IN (SELECT sq.empid FROM emp sq)
Would work to get the list.

You could, however, use a

I can;I've tried to replicate your problem, however, I get 0 values showing fine.

As it's only a picture of your report in Preview I can't tell, but is...

Click your Connection manager in your Connectin manager pane and hit F4. This'll display the Connection Manager's Property pane. On there, DelayValidation will be one of the properties. From recollection,...

Change the value of the Connection managers DelayValidation property to TRUE. This will stop pre package execution validation on it, and instead it will be validated when/if it is required.

Took me a minute, but:

Then click Go. 🙂