Repeated values in subreport

[mithilwane]

Hi,

I have a report with 2 suppliers. I want to show iems ordered by the 2 suppliers. For that I am using a subreport. 

For the 1st supplier there are 15 rows and second has 1.

But there are 2 many pages displayed. i.e. 92 pages. The values are repeated. Also a lot of empty pages are shown.

Please advise.

[Java_Jasper]

Hello,

My first guess when seeing repeted values is a group is triggering for every iteration of the main report thus giving you 92 pages of repeted information. I would double check the bands you are using are in fact triggering in the order you think they should.

A simple way to do this just of the top of my head would to be, create a group and in the group header place the main report, then in the group footer place the subreports. Thus not using the detail band, which wants to run every iteration of the main group. 

B.

[rob.naban]