I am using SSRS with MS SQL Server 2008 R2, which has the new feature of supporting shared datasets.
First, I created my shared dataset, and made sure that it worked correctly and had a good connection. That worked great.
Second, I created a new report (Let’s call it “ReportSub”), and I had it use my shared dataset. The report works great.
Third, I created another report (Let’s call is “ReportMain”), and I put a subreport object into the report and associated it with “ReportSub”. Doesn’t work. Instead, I get this error:
Data retrieval failed for the subreport, ‘ReportSub’, located at: /ReportSub. Please check the log files for more information.
Any ideas of what the problem may be? It will work if I use an embedded dataset, but I really need to use a shared dataset.
I ran into the same problems, too.
We recently upgraded from VS2003 and SQL2000 to VS2008 and SQL2008.
All reports+subreports were working fine in the previous version.
The only change I had to do was to have reports using custom(embedded) data sources, not shared.
When I try the subreports, they work fine. If I run the main report without subreports, again fine. But when put together, I get “Data retrieval failed for subreport…, located at: /RS2008. Please check the log files for more information”
And unfortunately, the log files are of not much help - they mention the above message again and again many times, without actually giving you further details.