I think you should try to deploy your report on the report server and then run it on the server itself. if it fails there then there is a problem.
Because sometimes preview of reports which get large amount of data fail.
I don't know any alternate solution to your problem
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQLPlease visit... ApplyBI