Results 1 to 4 of 4

Thread: Report Headers

  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Simple question I think. I'm trying to print a Report Header without displaying the Page Footer on it. And it would be really cool if my Page Footer Page counts didn't include the Report Header Page.
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    To hide the page footer on the report header page:
    - Open the report in design view.
    - Activate the Format tab of the Properties window.
    - In the Page Footer property, select "Not with report header".

    To exclude the report header page from the page number and page count, use ([Page]-1) for the page number, and ([Pages]-1) for the total number of pages, to get an expression like this:

    ="Page " & ([Page]-1) & " of " & ([Pages]-1)

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='777765' date='01-Jun-2009 05:42']To hide the page footer on the report header page:
    - Open the report in design view.
    - Activate the Format tab of the Properties window.
    - In the Page Footer property, select "Not with report header".

    To exclude the report header page from the page number and page count, use ([Page]-1) for the page number, and ([Pages]-1) for the total number of pages, to get an expression like this:

    ="Page " & ([Page]-1) & " of " & ([Pages]-1)[/quote]

    Good Morning Hans,

    Thanks kindly for the quick and accurate response. What I find most irksome is that as soon as I read your reply, I realized that I already "KNEW THIS", but had forgotten its location. Senility sucks!

    Thanks again,
    Cheers,
    Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I use the "Page Header" and "Page Footer" properties infrequently, so I always forget where they are too!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •