Problem with master-detail and subreports
Posted: Tue Nov 16, 2010 10:30 am
Environment : Visual Studio 2008 Team Suite with SP1, Reports.Web 2009.3
I'm trying to create a master-detail report with a sub-report but am having an issue with the data sources. I did the following;
1) Created a stored procedure which outputs 6 resultsets
2) Wrote some c# code to execute the stored procedure and capture the results in a DataSet, then save the schema and data to .xsd and .xml files.
3) Created a connection to XML data and select the .xsd and .xml files
4) Created two a relation
5) Created a DataBand on report bound to the parent table of the relation
6) Created a subreport
7) Created a DataBad on subreport bound to the child table of the relation.
It's the next bit that doesn't work properly. For the DataBand on the subreport, I can select the relation but there is no "Master Component" to select, it just says "None assigned". Without this my subreport outputs all records for each row in the main report, which is not good.
I've followed the video example (http://www.stimulsoft.com/livedemos/ste ... onent.html) but it's just not working.
Can anyone help?
Thanks
Phil
I'm trying to create a master-detail report with a sub-report but am having an issue with the data sources. I did the following;
1) Created a stored procedure which outputs 6 resultsets
2) Wrote some c# code to execute the stored procedure and capture the results in a DataSet, then save the schema and data to .xsd and .xml files.
3) Created a connection to XML data and select the .xsd and .xml files
4) Created two a relation
5) Created a DataBand on report bound to the parent table of the relation
6) Created a subreport
7) Created a DataBad on subreport bound to the child table of the relation.
It's the next bit that doesn't work properly. For the DataBand on the subreport, I can select the relation but there is no "Master Component" to select, it just says "None assigned". Without this my subreport outputs all records for each row in the main report, which is not good.
I've followed the video example (http://www.stimulsoft.com/livedemos/ste ... onent.html) but it's just not working.
Can anyone help?
Thanks
Phil