Enable remote errors in SSRS
Follow below procedure to enable remote error in SSRS
1) Open SQL Server Management studio and log in with reporting services as the service type.
2) right click on the instance and go to properties so here attach an image as the popup is shown after goto Advanced tab here you can find EnableRemoteError in Security tree.
After enabling remote error you can figure out actual error thrown by the database.
