When testing report it is useful to switch on the remote debugging so the error messages are displayed on your local system.
This can be done by running a SQL script against the reporting server database:
SET Value = ‘TRUE’
WHERE Name = ‘EnableRemoteErrors’
Remember to restart your reporting service after you make this change.