Is the following graph possible?...

<Knee-jerk reaction>
Yes, Create a T-SQL Stored Procedure that returns the set in the bottom image, then in SSRS create a data set that connects to it and a Matrix control to display the set, and some kind of expression in the textbox that will contain the X to show an X or empty string ''.

Thanks Jim, I will look into this and report back.

Any pointers on what the expressions will look like?

Vague, but I'll withdraw from the question to encourage active SQL Server experts to respond.  

My current gig is Oracle so I don't have my SQL Server cookbook 'O handy code in front of me.   If no one responds by the end of the day then I'll see what I can dig up from home.

lol thanks Jim

Jim, can a Matrix defo be used in this way? I can actually write the phase names across the top as they wont change, but not sure how the expression will query the dataset, so I will have a look around and keep an eye on this thread incase someone chimes in.

Ok so this is the expression so far....

=IIF((First(Fields!phase_name.Value = "HAZOP Verification", "fsp_roles_phases") AND First(Fields!role_name.Value = "Commissioning Engineer", "fsp_roles_phases")),"X","")

Sadly it gives an X in every row for the first column, which is not correct.

For me this expression worked:

=iif(count(Fields!role_name.Value)=1,"X","")

Select allOpen in new window

See the attached example. You need to change te data source for this example to work.
Matrix.rdl