This may or may not be helpful, but I ended up side stepping all this, by switching to the Report Viewer control. All the security is handled within the ASP.Net...

Since I requested help on this, I'm moved to using the latest Report Viewer control which does everything my client required and is significantly less hassle than messing about with...

Ok I've tried once more and here is the error when trying to run a report

Reporting Services Error

--------------------------------------------------------------------------------

The report server has encountered a configuration error. (rsServerConfigurationError) Get Online Help...

Verry unhelpfully it just said 'error'

Neither the Reports or Report Manager would work, I've switched it back again just for the moment so I can't actually see the errors.

Not much...

I realise you posted this some time ago and I got this all running just fine on my Dev server running SQL Server 2008 standard edition, but it certainly doesn't...

Well the most common approach would be write a CSV file to the server or directly to the browser. You could also use a reporting tool such as Excel Writer from Soft...

There are several ways to achieve what you want to do, but the level of access that your SQL Server login has will most likely determine the outcome.

I have in...