Thanks for the quick help Andras, but I've made a mistake, the data which is XML formatted is actually held in a ntext data type.

The actual need for this is...

I hope this formats ok, I've replaced brackets with &lt and &gt

&ltPolicies&gt

&ltPolicy&gt

&ltGroupUserName&gtJoe.Bloggs&lt/GroupUserName&gt

&ltRoles&gt

&ltRole&gt

...

If your data sources are on a different server to SSRS then this is a kerboros security issue by design (you cannot double hop), there are ways to get around...

I have raised this as a support incident with MS, and will post the resolution, if any, once resolved.

I didn't know that vista didn't experience the problem, I'll test that...

Thanks for the tip, I've now created a variable 'EmailTo' and hard coded an email address to it and assigned that to the ToLine expression as you suggested.

The only problem...

If the SQL Server data source is on a different server to the ReportServer then you would get this result, its a Kerberos double-hop thing.

You can still use SQL Authentication but...

Exactly, as I said, this is a 'view' that I have inherited and cannot change the calling application, so when testing an upgrade to sql 2005 we received different results...

You can create a view like this

create view vwX as

Select top 100 percent * from tblA order by X desc

This is the way a SQL 2000 view that I...

If the Report Explorer configuration on your sharepoint server the URL should be this

<A href="http:///reports">http://<servername>/reports where <servername> is the name of the server with RS installed.

The Start...

Thanks for the reply, I had just figured out that if the DB was on the same server as the Report Server then Trusted connectivity worked, so I guessed it...

Thanks Luke, this looks just what I was after.

Neil.