I am pushing the limits in Access 2003 with 7 layers of subreports defined.
For each item of the report there can be a group of sub-items, each of these sub-items can have a group of sub-items, and so on down 7 layers.
I am attempting to create a report that shows each item with it's sub-items in a layered format. I have the item listed in the detail section with a sub-report pasted just below it. The sub-report contains a sub-report and so on down 7 layers. The border of each sub-report is turned on and indented slightly for each group of sub-items.
It reports all the data but I want to make it more readable where one of these boxes spans more then one page.
To do this in the top level I copied fields from the detail section to the Page Header section. This adds the header to the top of each page in addition to the detail the top-most item. When that item has several sub-items spanning multiple pages on the report it also puts that item at the top of each subsequent page.
You might think that the sub-reports would behave the same way but they do not. When I add the Page Header section to each sub-report, it prints it on the first occurance only and does not print it on subsequent pages. As a result it is difficult to tell what sub-report item you are on.
I have tried using the various events available to assign unbound fields in the Page Heading of the sub-report with the sub-report's current item. It does not seem to help.
When I run the sub-report by itself, as a main report, then it works as expected, printing the item at the top of each page.
For each item of the report there can be a group of sub-items, each of these sub-items can have a group of sub-items, and so on down 7 layers.
I am attempting to create a report that shows each item with it's sub-items in a layered format. I have the item listed in the detail section with a sub-report pasted just below it. The sub-report contains a sub-report and so on down 7 layers. The border of each sub-report is turned on and indented slightly for each group of sub-items.
It reports all the data but I want to make it more readable where one of these boxes spans more then one page.
To do this in the top level I copied fields from the detail section to the Page Header section. This adds the header to the top of each page in addition to the detail the top-most item. When that item has several sub-items spanning multiple pages on the report it also puts that item at the top of each subsequent page.
You might think that the sub-reports would behave the same way but they do not. When I add the Page Header section to each sub-report, it prints it on the first occurance only and does not print it on subsequent pages. As a result it is difficult to tell what sub-report item you are on.
I have tried using the various events available to assign unbound fields in the Page Heading of the sub-report with the sub-report's current item. It does not seem to help.
When I run the sub-report by itself, as a main report, then it works as expected, printing the item at the top of each page.
Comment