Hiding Details on first page of each new group

  • Thread starter Thread starter Rudy B
  • Start date Start date
R

Rudy B

I have a report where the first page of each new group
needs to be a summary page. The details need to begin on
page 2 of each group. Therefore, I only need header &
footer information on page 1.

Further information is as follows. I have a report grouped
by company and month. The detail includes transactional
data. On the first page of each group, I would like to
suppress the detailed transactional data and only display
totals for the group.

Thanks.

Rudy B.
 
Rudy said:
I have a report where the first page of each new group
needs to be a summary page. The details need to begin on
page 2 of each group. Therefore, I only need header &
footer information on page 1.

Further information is as follows. I have a report grouped
by company and month. The detail includes transactional
data. On the first page of each group, I would like to
suppress the detailed transactional data and only display
totals for the group.
Click to expand...


What kind of totals dor the group do you have?

If they're just text boxes with aggregate function
expressions (Count, Sum, Avg, etc) then you put those in the
group header section. Set the group header's Force New Page
property to After Section to push the details to the next
page.
 
Thanks Marsh

After some trial & error last night, I found the solution
to my problem was a simple as inserting a page break in
the group header. This forced all detail records onto
subsequent pages and left only the group header and page
footer on the first page. My page and group footers are
displayed dynamically based on which page the report is on
and my subtotals are displayed in the page footer.

Rudy B.
 
Rudy said:
Thanks Marsh

After some trial & error last night, I found the solution
to my problem was a simple as inserting a page break in
the group header. This forced all detail records onto
subsequent pages and left only the group header and page
footer on the first page. My page and group footers are
displayed dynamically based on which page the report is on
and my subtotals are displayed in the page footer.
Click to expand...

Glad you've got it working. If you prefer to use the
PageBreak control instead of the ForceNewPage property, just
make sure the PageBreak control is at the bottom of the
header section so that some (small?) part of it dosen't get
pushed to the next page.

You have subtotals in the page footer? It sounds like you
have a cpmplicated report, not to mention a little tricky.
But, as long as you're happy. I'm happy ;-)
 
Back
Top