Page 1 of 2

Problem with master-detail and subreports

Posted: Tue Nov 16, 2010 10:30 am
by Philip Street
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

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 3:47 am
by Ivan
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.

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 5:33 am
by Philip Street
Ivan 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.
Hi Ivan

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

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 6:13 am
by Ivan
Hello,

Please send your sample files to support@stimulsoft.com

Thank you.

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 6:19 am
by Philip Street
Ivan wrote:Hello,

Please send your sample files to support@stimulsoft.com

Thank you.
Done, just emailed them to you.

Thanks

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 7:10 am
by Alex K.
Hello,

Ok!

Thank you.

Problem with master-detail and subreports

Posted: Wed Nov 17, 2010 7:49 am
by Ivan
Hello,

Please place the subreport directly on the databand instead of container.

Thank you.

Re: Problem with master-detail and subreports

Posted: Thu Mar 17, 2016 12:04 pm
by krauss@viasw.com.br
Ivan wrote:Hello,

Please place the subreport directly on the databand instead of container.

Thank you.
Hello,

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

Posted: Thu Mar 17, 2016 12:19 pm
by Alex K.
Hello,

Please send us your report for analysis.

Thank you.

Re: Problem with master-detail and subreports

Posted: Thu Mar 17, 2016 5:13 pm
by krauss@viasw.com.br
Aleksey wrote:Hello,

Please send us your report for analysis.

Thank you.
Report sent via e-mail.

Thank you