Subreport producing multiple results

Posted on October 10, 2015 at 2:32pm

Hi,

I am having some trouble with my subreport reproducing results in my main report by the number of rows produced in the subreport. So if my subreport has three rows in it, the main report will produce three subreport sections, each with three rows in it. I hope I have explained this well enough

I know this is something really easy, but I have jacked with it all day.

TIA 

Tim

JasperReports® Server
timopp's picture
timopp
11
Joined: Sep 8 2015 - 4:23pm
Last seen: 7 years 4 months ago

3 Answers:

Posted on October 11, 2015 at 1:24am

Hi,

It seems your main dataset query generates three rows and you subreport is on detail band. Put subreport on summary band or change main dataset as generating one dummy record if it is not in use.

zh3ntil's picture
zh3ntil
3297
Joined: Nov 19 2014 - 11:02pm
Last seen: 6 years 10 months ago
Posted on October 11, 2015 at 7:15am

Thanks.

Could you detail this part?

or change main dataset as generating one dummy record if it is not in use.

Tim

timopp's picture
timopp
11
Joined: Sep 8 2015 - 4:23pm
Last seen: 7 years 4 months ago
Posted on October 11, 2015 at 9:00am

If your main dataset result doesn't fill any field on main report, you can use a query like 'select 1 as field' just to be sure the dataset returns at least a row. Because if your dataset returns no result, your report shows no data section. So, If your main dataset returns a dummy result like that just a row, your detail section runs just one time.  

zh3ntil's picture
zh3ntil
3297
Joined: Nov 19 2014 - 11:02pm
Last seen: 6 years 10 months ago
Feedback