Suppressing Page Headers on Report Footer 
Author Message
 Suppressing Page Headers on Report Footer

I have a report that consists of over 1000 invoices. I want to have a report
summary on the last physical page (using page break before). But how do I
suppress the page headers so the last invoice header info does not repeat on
the summary page. To make things tricky, there are currently 25 page header
sections and I reset the page count for each invoice. If I suppress on
OnLastRecord the last invoice is affected.

I am using 8.5 and 9.

TIA
Rob



Mon, 01 Aug 2005 06:12:15 GMT  
 Suppressing Page Headers on Report Footer
Hi Rob,
    Could you put another page header section above the others?  In this
section insert a formula that uses a variable to keep a running count of the
pages.  Then suppress your headers when the variable equals the
"totalpagecount".  I haven't tried this, but it might work.

Bob Holmes


Quote:
> I have a report that consists of over 1000 invoices. I want to have a
report
> summary on the last physical page (using page break before). But how do I
> suppress the page headers so the last invoice header info does not repeat
on
> the summary page. To make things tricky, there are currently 25 page
header
> sections and I reset the page count for each invoice. If I suppress on
> OnLastRecord the last invoice is affected.

> I am using 8.5 and 9.

> TIA
> Rob



Mon, 01 Aug 2005 21:18:19 GMT  
 Suppressing Page Headers on Report Footer
Bob

Thanks, but I tried that. Unfortunaly since I reset the page count for each
"Invoice" this does not work.

Rob


Quote:
> Hi Rob,
>     Could you put another page header section above the others?  In this
> section insert a formula that uses a variable to keep a running count of
the
> pages.  Then suppress your headers when the variable equals the
> "totalpagecount".  I haven't tried this, but it might work.

> Bob Holmes



> > I have a report that consists of over 1000 invoices. I want to have a
> report
> > summary on the last physical page (using page break before). But how do
I
> > suppress the page headers so the last invoice header info does not
repeat
> on
> > the summary page. To make things tricky, there are currently 25 page
> header
> > sections and I reset the page count for each invoice. If I suppress on
> > OnLastRecord the last invoice is affected.

> > I am using 8.5 and 9.

> > TIA
> > Rob



Tue, 02 Aug 2005 01:51:35 GMT  
 Suppressing Page Headers on Report Footer
Hi Rob,
    Sorry.  I should have tried it out first.  I thought the
"TotalPageCount" would return the number of pages regardless of how you had
them individually numbered.

Bob Holmes


Quote:
> Bob

> Thanks, but I tried that. Unfortunaly since I reset the page count for
each
> "Invoice" this does not work.

> Rob



> > Hi Rob,
> >     Could you put another page header section above the others?  In this
> > section insert a formula that uses a variable to keep a running count of
> the
> > pages.  Then suppress your headers when the variable equals the
> > "totalpagecount".  I haven't tried this, but it might work.

> > Bob Holmes



> > > I have a report that consists of over 1000 invoices. I want to have a
> > report
> > > summary on the last physical page (using page break before). But how
do
> I
> > > suppress the page headers so the last invoice header info does not
> repeat
> > on
> > > the summary page. To make things tricky, there are currently 25 page
> > header
> > > sections and I reset the page count for each invoice. If I suppress on
> > > OnLastRecord the last invoice is affected.

> > > I am using 8.5 and 9.

> > > TIA
> > > Rob



Tue, 02 Aug 2005 03:07:37 GMT  
 Suppressing Page Headers on Report Footer
Thats OK, I used the "OnLastRecord" function. It seems  to work as an EOF
indicator, even though the documentation says otherwise. So my last record
actually prints it's invoice then this is set to True.

Rob


Quote:
> Hi Rob,
>     Sorry.  I should have tried it out first.  I thought the
> "TotalPageCount" would return the number of pages regardless of how you
had
> them individually numbered.

> Bob Holmes



> > Bob

> > Thanks, but I tried that. Unfortunaly since I reset the page count for
> each
> > "Invoice" this does not work.

> > Rob



> > > Hi Rob,
> > >     Could you put another page header section above the others?  In
this
> > > section insert a formula that uses a variable to keep a running count
of
> > the
> > > pages.  Then suppress your headers when the variable equals the
> > > "totalpagecount".  I haven't tried this, but it might work.

> > > Bob Holmes



> > > > I have a report that consists of over 1000 invoices. I want to have
a
> > > report
> > > > summary on the last physical page (using page break before). But how
> do
> > I
> > > > suppress the page headers so the last invoice header info does not
> > repeat
> > > on
> > > > the summary page. To make things tricky, there are currently 25 page
> > > header
> > > > sections and I reset the page count for each invoice. If I suppress
on
> > > > OnLastRecord the last invoice is affected.

> > > > I am using 8.5 and 9.

> > > > TIA
> > > > Rob



Tue, 02 Aug 2005 03:21:51 GMT  
 Suppressing Page Headers on Report Footer
That's good to know.  Thanks for telling us.

Bob Holmes


Quote:
> Thats OK, I used the "OnLastRecord" function. It seems  to work as an EOF
> indicator, even though the documentation says otherwise. So my last record
> actually prints it's invoice then this is set to True.

> Rob



> > Hi Rob,
> >     Sorry.  I should have tried it out first.  I thought the
> > "TotalPageCount" would return the number of pages regardless of how you
> had
> > them individually numbered.

> > Bob Holmes



> > > Bob

> > > Thanks, but I tried that. Unfortunaly since I reset the page count for
> > each
> > > "Invoice" this does not work.

> > > Rob



> > > > Hi Rob,
> > > >     Could you put another page header section above the others?  In
> this
> > > > section insert a formula that uses a variable to keep a running
count
> of
> > > the
> > > > pages.  Then suppress your headers when the variable equals the
> > > > "totalpagecount".  I haven't tried this, but it might work.

> > > > Bob Holmes



> > > > > I have a report that consists of over 1000 invoices. I want to
have
> a
> > > > report
> > > > > summary on the last physical page (using page break before). But
how
> > do
> > > I
> > > > > suppress the page headers so the last invoice header info does not
> > > repeat
> > > > on
> > > > > the summary page. To make things tricky, there are currently 25
page
> > > > header
> > > > > sections and I reset the page count for each invoice. If I
suppress
> on
> > > > > OnLastRecord the last invoice is affected.

> > > > > I am using 8.5 and 9.

> > > > > TIA
> > > > > Rob



Tue, 02 Aug 2005 03:40:53 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. First page prints only report header and page footer

2. Suppress Main Reports Page Header on sub-report

3. Display page footer on report header

4. suppress page footer section in the last page

5. First page of report has header/footer but nothing else

6. How to suppress group header when page header is the same

7. How to customize or suppress header and footer when printing from WebBrowser control

8. How to customize/suppress header and footer when printing from WebBrowser control

9. How to customize or suppress header and footer when printing from WebBrowser control

10. How to customize/suppress header and footer when printing from WebBrowser control

11. Page Header and Page Footer Problem

12. Page Header and Page Footer disappear

 

 
Powered by phpBB® Forum Software