report with one record on more pages

[l_ionesco]

Hello, I have the following situation: one table "departments" with more fields and one table "peoples" with more fields, one field is the department that belongs people. Problem: I need to build a report which contains for each people the departments data and people's data: eg. if we have "Department 1" with "People 1", "People 2"  and " "Department 2" with "People 3" then the report must be: 

 

Header: Department 1 data

Detail: People 1 data

Header: Department 1 data

Detail: People 2 data

Header: Department 2 data

Detail: People 3 data

Solutions that did not work:

1. Create master report with data source "department" table, put in header data from department, create subreport with data source "peoples" table, one record /page. Solution is ok if it fits one single page / record. In our case there are more pages / people. I try to create more detail bands but generates fill error.

2. Create group, put in group header the departments data and in details people data (subreport or not). It is not good for me, I want each people in report to have the department data before.

I use iReportDesigner 5.6.0, DataBeans connection.

Any suggestions, thank you very much.

[Tom C]

You can make two lines in your detail band - one for depetment data ("header"), and the other for people data. Will this work for you to meet the design requirment?

[l_ionesco]

Thanks for the reply. If I use two lines (without sub-report)I must have a data-source with department data for each people record. For example: people 1 must have attached department 1 data, people 2 must have same department 1 data again etc. I think I have a redundancy in stored data...

[l_ionesco]

I found a solution for my problem: create group with $F{people_name} (or id, or something that identify people) in group expression. In header group put department data  and in details people data - build more details bands for more pages - and CHECK "Start on a new page" in group properties. That works for me.