Problem with master-detail and subreports

Stimulsoft Reports.WEB discussion
Philip Street
Posts: 9
Joined: Tue Jun 30, 2009 10:07 am
Location: London, UK

Problem with master-detail and subreports

Post 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
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Problem with master-detail and subreports

Post 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.
Philip Street
Posts: 9
Joined: Tue Jun 30, 2009 10:07 am
Location: London, UK

Problem with master-detail and subreports

Post 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
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Problem with master-detail and subreports

Post by Ivan »

Hello,

Please send your sample files to support@stimulsoft.com

Thank you.
Philip Street
Posts: 9
Joined: Tue Jun 30, 2009 10:07 am
Location: London, UK

Problem with master-detail and subreports

Post by Philip Street »

Ivan wrote:Hello,

Please send your sample files to support@stimulsoft.com

Thank you.
Done, just emailed them to you.

Thanks
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Problem with master-detail and subreports

Post by Alex K. »

Hello,

Ok!

Thank you.
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Problem with master-detail and subreports

Post by Ivan »

Hello,

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

Thank you.
krauss@viasw.com.br
Posts: 2
Joined: Thu Mar 17, 2016 11:43 am

Re: Problem with master-detail and subreports

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with master-detail and subreports

Post by Alex K. »

Hello,

Please send us your report for analysis.

Thank you.
krauss@viasw.com.br
Posts: 2
Joined: Thu Mar 17, 2016 11:43 am

Re: Problem with master-detail and subreports

Post by krauss@viasw.com.br »

Aleksey wrote:Hello,

Please send us your report for analysis.

Thank you.
Report sent via e-mail.

Thank you
Post Reply