It seems like shared dataset/datasource is not working if a report is used as a subreport. Please let me know if anyone is able to use shared dataset with subreport.

I have this problem for "preview" only. As soon as I deploy this to Reporting Service server it starts working fine.

Hi, Thanks for finding this question about shared datasource/dataset. Currently, there is no way to Preview the subreport with shared datasource/dataset in BIDS. I would suggest you submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope microsoft correct it in the next release of SSRS service pack. thanks, Jerry

Did you submit feedback to MS? If so do you have the link so that I could recommend this gets resolved as well. Thanks!Matt Klepeis

I believe this is the feedback item your looking for: https://connect.microsoft.com/SQLServer/feedback/details/648560/subreport-with-shared-dataset-throws-error Although it also happens I believe when the subreport is using a shared dataset.

Hello, I am using SSRS with MS SQL Server 2008 R2. I created my dataset, and it worked correctly and I created a new report, and I had it use my dataset. The report works correctly. I created another report , and I put a subreport object into the report and associated it with the first report. I get this error: "Data retrieval failed for the subreport... Please check the log files for more information." Any ideas of what the problem may be? Despite i don't use a shared dataset. Thanks,

Hello, I am using SSRS with MS SQL Server 2008 R2. I created my dataset, and it worked correctly and I created a new report, and I had it use my dataset. The report works correctly. I created another report , and I put a subreport object into the report and associated it with the first report. I get this error: "Data retrieval failed for the subreport... Please check the log files for more information." Any ideas of what the problem may be? Despite i don't use a shared dataset. Thanks, You claim you're not using shared datasets but you were able to create your dataset before creating your report. Sounds exactly like a shared dataset to me...MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)