Getting the error "Data retrieval failed for the subreport, 'Subreport1'" while trying to preview a report from Business Intelligence Studio

Question

I know this question has been asked before, but all questions were for reports being accessed using C# or VB.NET code. My problem is that I am building and accessing the report using Business Intelligence studio, I am basically trying to add a sub report for a report, and I made sure from the parameters and they are OK. However when I try to access the report containing the subreport, I get the error

Data retrieval failed for the subreport, 'Subreport1'.

I also tried deleting the .data files but the same problem persisted.

Answer 1

I faced similar issue in past and in my case below were the culprit's

1. Parameter from main report is sending null value to sub report.

2. Data type of parameter were different than actual data type.

Answer 2

I had the same problem when the dataset’s subreport filters the data by the "Filters" functionality (Filter tab), but when change the filter method by the use of sql parameters (Parameters Tab) it Works.