Over the last couple of weeks I have had a number of clients ask me the same thing when creating reports with sub reports in SQL Server Reporting Services 2008 R2, which is how do I get them to work?
When the user previews the report SSRS 2008 R2 returns the following error message:
“Data retrievel failed for subreport ‘SubreportName’ located at
/ParentReportName.
Please check the log files for more information”
Solution:
There seems to be a bit of an undocumented feature within the Business Intelligence Development Studio (BIDS), with regards to Shared Datasets and sub reports in SSRS 2008 R2.
When designing sub reports within SSRS 2008 R2, design the reports with an Embedded Dataset
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
|
