Subreport to trigger based on current result set

[Java_Jasper]

Hello All,

I have a subreprot that is passed a paramater from the main report, I will cal it "ID". In the main report I have a query to select say 10 IDs.

When I run the report I get the 10 different IDs and 10 subreports. However the subreport only triggers on the very first ID (thus I have 9 subreorts with the same info). How can I get it to trigger on each ID like in the main report?

 

Thanks in advance!

[gocmenally]

when u put ur subreport on Detail, main report will send IDs. If u done this u  can see 10 subreports.

[hishamkmr]

do u put the subreport in detail band of main report?

[Java_Jasper]

Hello,

 

I have a section already in the detail section, where info is printed. When I have said data print it becomes fractured. Thus (data --> Sub Report) is printed over and over not the desired result.

 

Thx.

[Java_Jasper]

Please see above.

[Java_Jasper]

Hello all,

So after trying for some time to figure this problem out here is the solution that worked for me.

1. I made sure I was calling said IDs in my sql.
2. In order to make my IDs trigger for each iteration of the report I used several "Group Headers" I did this because the headers are evaluated once per cycle per-say.
3. I then placed a sub report into the footer of said report and passed it the "Field" which is $F{ID}, thus when the sql is called upon it gives the ID found at that moment in time to the sub report.
4. The end result is a sub report that triggers, every time the header is evaluated.

I know this is a bit of a hack but ENJOY!