If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Page headers and multipage sub reports
My report consists of 2 sub reports one below the second. The first
is a short (1/4 page) summary, the latter contains a more detailed breakdown of the data and can span several pages. The problem I have is that when it flows onto a second page it will not display headers. For the first page I can work around the subreport not showing a header by copying the labels into the report header section, but that doesn't help for when it spans onto the second page. I can't use the parent reports headers either, because they'd appear at the top of the first page, above the summary subreport. Is there a way around this, or will I have to split this into two separately printed reports? |
#2
|
|||
|
|||
Page headers and multipage sub reports
Create a new primary/top level sorting and grouping level (in your subreport)
on a constant expression like: =1 Display the group header for this level. Set the "Repeat Section" property of the =1 Group Header to "Yes". Use this section in place of a page header -- Duane Hookom Microsoft Access MVP "Dan Neely" wrote: My report consists of 2 sub reports one below the second. The first is a short (1/4 page) summary, the latter contains a more detailed breakdown of the data and can span several pages. The problem I have is that when it flows onto a second page it will not display headers. For the first page I can work around the subreport not showing a header by copying the labels into the report header section, but that doesn't help for when it spans onto the second page. I can't use the parent reports headers either, because they'd appear at the top of the first page, above the summary subreport. Is there a way around this, or will I have to split this into two separately printed reports? |
Thread Tools | |
Display Modes | |
|
|