the output from the above query is attached for your information

Hi there

OK here goes

This is my complete query

SELECT

Ok here is an updated screenshot

This Is a screenshot of the Tablix in Design View

This is how my report looks like at the moment.

I really only want to display one Instance of the label 'IBOS Broker Code'

So in actual fact, it...

Adi Cohn-120898 (12/1/2016)

---

As this feature's name implies it is completely transparent to the clients, so no code would have to be rewritten. The things that you do have to...

That's brilliant and works for me . Thanks so much guys for your help on this.

Thanks guys for that.it worked.

OK if I need to extract another item from that pice of xml then do I write this folowing

SELECT

SX.OldRow.value('(Airline/@lastUpdatedByUserID)[1]','INT') AS lastUpdatedByUserID,

...

Andrew Pirie (4/29/2015)

---

Great - glad you've got this working. I would have given more direct suggestions if I had access to a PC with SSRS installed earlier, so sorry about...

Andrew Pirie (4/29/2015)

---

In Reporting Services Configuration Manager, go to the Web Service URL tab, and click the hyperlink beside URLs: under Report Server Web Service URLs. This should bring up...