Thanks for help but think I have solved it in SSRS now! By manipulating the Matrix in a different way, I have managed to get the results I was...

Hi Jeff

Thanks for your pointers.

I have managed to get somewhere using the following...

Creating the original view...

SELECT dbo.hl_enquiry.enquiry_refno, dbo.hl_attribute.attrib_code, dbo.hl_attribute.sub_attrib_code, dbo.hl_attribute.date_value

FROM ...