I need to create a risk matrix report as below using SSRS?

Can anyone help me? I have been able to create one similar using a matrix but is the risk doesn't have a rating, the row or column will not show and therefore the matrix changes size? which isn't really what the client wants.

Any help would be amazing!

Thanks in advance! 

• Edited by chesternut Monday, September 08, 2014 1:41 PM

Hi chesternut,

According to your description, you want to create a matrix with different background color based on the value in textbox. Right?

In Reporting Services, matrix generate columns based on the column group. In this scenario, if you want to specify different background color of textbox, you can use switch() function to set it. Please refer to the expression below:

=Switch(ReportItems!textbox.Value>0,"Red",.......,ReportItems!textbox.Value=0,"Green")

Reference:
Expression Examples (Report Builder and SSRS)

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

Best Regards,
Simon Hou

• Edited by Simon_HouMicrosoft contingent staff, Moderator Wednesday, September 10, 2014 1:28 PM

Hi Simon,

The colour part is fine- thanks for your comment though. I really appreciate it.

What I'm having trouble with is, is creating fixed columns and rows (so that the matrix is always 5x5). Basically, if there isn't data for each square in the 5x5 matrix, the matrix shrinks, showing only the data it has. I've attached some screen shots. Any help would be greatly appreciated!!

• Edited by chesternut Wednesday, September 10, 2014 1:50 PM

Hi chesternut,

This is the feature of matrix. Even we fix columns and rows of matrix, when the data is not enough for populating the matrix, it will shrink automatically. We can't force it populating 5*5 area with blank textbox.

Reference:
Matrices (Report Builder and SSRS)

Best Regards,
Simon Hou

Hey Simon, 

Thanks a million for your help? Do you know if there would be another way of doing this? Maybe using a table? 

Cheers :)