Problem with master-detail and subreports
-
- Posts: 9
- Joined: Tue Jun 30, 2009 10:07 am
- Location: London, UK
Problem with master-detail and subreports
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
Problem with master-detail and subreports
Hello,
Please check that the SubReport is placed on the Master DataBand.
If the issue is still present, please send to us a sample report with data or a simple test application, which reproduces the issue, for analysis.
Thank you.
Please check that the SubReport is placed on the Master DataBand.
If the issue is still present, please send to us a sample report with data or a simple test application, which reproduces the issue, for analysis.
Thank you.
-
- Posts: 9
- Joined: Tue Jun 30, 2009 10:07 am
- Location: London, UK
Problem with master-detail and subreports
Hi IvanIvan wrote:Hello,
Please check that the SubReport is placed on the Master DataBand.
If the issue is still present, please send to us a sample report with data or a simple test application, which reproduces the issue, for analysis.
Thank you.
I thought I had cracked it by setting the Sub Report Page property to Not Assigned, then setting it back to subReport_1, i.e. it worked the first time I tried it but now it doesn't.

Can I email the files to you?
Thanks
Phil
-
- Posts: 9
- Joined: Tue Jun 30, 2009 10:07 am
- Location: London, UK
Problem with master-detail and subreports
Done, just emailed them to you.
Thanks
Problem with master-detail and subreports
Hello,
Ok!
Thank you.
Ok!
Thank you.
Problem with master-detail and subreports
Hello,
Please place the subreport directly on the databand instead of container.
Thank you.
Please place the subreport directly on the databand instead of container.
Thank you.
-
- Posts: 2
- Joined: Thu Mar 17, 2016 11:43 am
Re: Problem with master-detail and subreports
Hello,Ivan wrote:Hello,
Please place the subreport directly on the databand instead of container.
Thank you.
I'm having the same problem.
I insert the subreport component on my databand1 in page1 then select the page2 for the subreport.
When I put a new databand on page2 and try to assign a Master Component, my databand on page1 doesn't apear and only shows 'Not Assigned'.
Best regards
Re: Problem with master-detail and subreports
Hello,
Please send us your report for analysis.
Thank you.
Please send us your report for analysis.
Thank you.
-
- Posts: 2
- Joined: Thu Mar 17, 2016 11:43 am
Re: Problem with master-detail and subreports
Report sent via e-mail.Aleksey wrote:Hello,
Please send us your report for analysis.
Thank you.
Thank you