Mighty helpful, thank you. I know it has been several years on, but this is exactly what was happening with me.

In one report against SSAS, I had...

I solved it, which is a hack but will have to do.

Report title in its own rectangle with bottom border only serving as a separator line.

Chart in its own rectangle.

New...

Great thought!

But my God... I had failed to add the Reporting Services Browser User to the Linked Server Remote Server Login Mappings.

In the end I still deserve a...

I was able to solve this with the following query. A classic example of over thinking this whole thing. Thanks for your ear!

SELECT *,

(SELECT

TOP 1 CashierNo

FROM Ticket_CashierSignOn...

Brilliant! I am off and running. For anyone in future that follows this thread this is what I ended up with:

DECLARE @iDoc INT

DECLARE @xmlDoc XML

SET @xmlDoc = (SELECT * FROM...

Mark,

Cheers for the excellent response. Using my example that I provided I see how this caters to my needs. Unfortunately I dumbed down my example, here's a sample chunk of...