Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be quick to take advantage of an advantage
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

21
May

How Do I Get Sub-Reports to work in SQL Reporting Services 2008 R2?

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


MAKE A COMMENT

Name *

Email Address *

Comment *