Hi - thanks for the reply. We resolved this issue in the end by amending the security permissions the account running the report to have modify permissions to C:\Windows\Temp on both the database server and also on the application server where reporting services sits.

Hopefully that helps anyone that has a similiar issue.

Thanks for posting your suggestion though.:-)