View Single Post
  #6  
Old June 7th, 2010, 02:54 PM posted to microsoft.public.access.reports
VBNovice10
external usenet poster
 
Posts: 7
Default Force the group footer to print on the first page

My report is based off of a current form we manually create through Microsoft
Word for every customer. Each customer may have anywhere from 1 to 300
items, so the detail section length varies. But I want to populate the
report through Access from my database to expedite the former form creation.

My report has a report header with a logo, a page header with recurring data
on each page, a detail section with rows of data populated by rows in my
database, a group footer, a page footer with page numbers, and a report
footer which takes up the entire last page.

I was hoping there was a code/method to force the group footer to always
print on the "first page" only regardless of the number of rows in the detail
section. The main question is can a group footer be forced to print in the
middle of a group section?

Thank you for your help. Please let me know if you need more detail.

"Wolfgang Kais" wrote:

Hello.

"VBNovice10" wrote:
Does anyone know how to force the group footer to print only on the
first page of an Access 2007 Report?


Wolfgang Kais wrote:
You could try to change the visibility of the group footer section
in it's format event, using a line like this:

Me.NameOfTheGroupFooterSection.Visible = (Me.Page = 1)


"VBNovice10" wrote:
Thank you for your help, but the code didn't work. The group footer
still did not appear on the first page. I may have to reconsider my
report design.


As Marshall Barton said, make sure that the section you associate the
code with is indeed the section you want to hide/display, and that the
name of the section used in code is correct. Always keep in mind that
a group footer will be displayd below the last detail record of
the group (on the same page, provided that there is enough space).
You could also verify the ForceNewPage property of the group footer.
Did you accidently set this property to "before section"?
You said "the group footer still did not appear on the first page".
Still? I thought that is WAS displayed and you wanted it to be displayed
ONLY on the first page? What is the page number of the desired page?

--
Regards,
Wolfgang


.