I'm getting rusty. It has been a while...
Two tables, one for person and one for gadget. One-to-many relationship, a person can own multiple gadgets.
I want report to first displays all people contained in this report. Below is a list of all gadget owned by people. (The normal approach would be to group per person and thus list all gadgets per person. However, that is not what I want to achieve. I want to show a pool of people owning a pool of gadgets.)
A subreport is currently placed in header of main report listing all persons. Detail section has all the relevant gadgets.
Problem is having multiple people. As the header grows, the detail section should accordingly start further down, but it doesn't. Detail section begins in the fixed same place regardless of how the header grows. Some people end up not being displayed because of the fixed height of the page header. The auto-height property of the page header section doesn't do the job. Have tried making subreport exact same width as report but to no avail.
Any comments or ideas most welcome.
Two tables, one for person and one for gadget. One-to-many relationship, a person can own multiple gadgets.
I want report to first displays all people contained in this report. Below is a list of all gadget owned by people. (The normal approach would be to group per person and thus list all gadgets per person. However, that is not what I want to achieve. I want to show a pool of people owning a pool of gadgets.)
A subreport is currently placed in header of main report listing all persons. Detail section has all the relevant gadgets.
Problem is having multiple people. As the header grows, the detail section should accordingly start further down, but it doesn't. Detail section begins in the fixed same place regardless of how the header grows. Some people end up not being displayed because of the fixed height of the page header. The auto-height property of the page header section doesn't do the job. Have tried making subreport exact same width as report but to no avail.
Any comments or ideas most welcome.