Getting the error “Data retrieval failed for the subreport, ‘Subreport1′” while trying to preview a report from Business Intelligence Studio

reporting-servicessql-server-2008-r2ssrs-2008

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.

Best Answer

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

Parameter from main report is sending null value to sub report.
Data type of parameter were different than actual data type.

Related Solutions

SSRS Subreport VS2010 data retrieval failed for the subreport

From Jin Chen Microsoft, ModeratorUsers Medals the answer on the msdn forum http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5d2aed0b-ea69-4cbb-b3c4-b306a48fbc30

THANK YOU SO MUCH!!!

I did have this code but I had the event added in the form designer which I added via the GUI event property window thing

and following your example I moved this line

reportViewer1.LocalReport.SubreportProcessing += new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(this.reportViewer1_suberport1);

From the form.designer.cs to after the refresh report as you did in your example and NOW IT WORKS!!!

Thank you awesome thanksgiving, whew

reportViewer1.RefreshReport(); reportViewer1.LocalReport.SubreportProcessing += new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(this.reportViewer1_suberport1);



   private void reportViewer1_suberport1(object sender, SubreportProcessingEventArgs e)
    {

        ReportDataSource r=reportViewer1.LocalReport.DataSources[0];
        e.DataSources.Add(r);

    }

Error: Subreport could not be shown. Sub Report works in Preview – but not when deployed

Issue resolved. I needed to deploy my subreport as well, not just build.

Best Answer

Related Solutions

SSRS Subreport VS2010 data retrieval failed for the subreport

Error: Subreport could not be shown. Sub Report works in Preview – but not when deployed

Related Topic