I'm trying to use the report designer in Visual Studio 2010 for the first time. It's pretty straightforward and I've got my main report working just fine. It's a local report (RDLC).
Now I want to add a subreport and I'm having trouble. I've created the subreport and it runs perfectly on its own, but when I add it to the main report and run the main report the main report works but where the subreport should be is a message which says:
Data retrieval failed for the subreport
followed by the path to the report. I'm passing the only parameter that the subreport requires from the main report, just specifying a static value for now until I get it working, at which point I'll change it to an expression. I do have two SQL data sources on my page with the ReportViewer, one which corresponds to the required data for the main report and one for the subreport. I don't know if this is the right way of doing it but I've tried just using one data source with all of the fields in it instead and that didn't work either.
Tutorials for the report designer and subreports are few and far between but those I can find make it seem very simple and I can't see what I'm doing wrong!
View Complete Post