Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report footer goes to next page (2007)

    I have some reports that have page and report footers. It seems that if I change those reports to contain two or more columns, that causes the report footer to go to a second page. I can't seem to figure it out. Am I missing something?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report footer goes to next page (2007)

    Try experimenting with the page margins and the column settings (space between, for example).

    If you can't work it out, could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Report footer goes to next page (2007)

    Is the width of the footer (that is, that space occupied by controls) exceed the width of a column?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report footer goes to next page (2007)

    Not that I can tell--well, they were, but I shortened them and moved them all to the left and that seemed to make no difference.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report footer goes to next page (2007)

    Hi
    I haven't played with columns in reports but I found this in Access help.

    When a multiple-column report is printed, the report header and footer and page header and footer span the full width of the report, but the group header and footer and detail section of a multiple-column report span the width of one column .

    Might it be something to do with this which is causing the extra page?
    Silverback
    Silverback

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report footer goes to next page (2007)

    Are you talking about the report footer or a page footer? The report footer only prints once, on the last page of the report, while the page footer prints on each page. If the report footer is taller than the page footer, then it's entirely possible that it will print on a second page even though all the items in the snaking columns appear on the first page, especially if your columns are snaked down then across.
    Charlotte

  7. #7
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report footer goes to next page (2007)

    OK...thanks for all the efforts from everyone. It is the report footer that wants to go to a second page, seemingly regardless of what I have tried with margins, etc. Now I see that ii is also true that if I change to "Across, then Down" for the columns (which is, of course, not the way I want the report to display), everything pulls up nicely onto one page. I don't understand the comment about the report footer being "taller" than the page footer, Charlotte. Can you explain further?

    Thanks again for all the help?

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report footer goes to next page (2007)

    First off, you need to understand that the report footer doesn't have a fixed location, while the page footer does. As a result, when the report is being laid out for printing, the column is broken and snaked after the last record that will fit in above the page footer. It doesn't care if all you have is one more record after that, it fills the first column. If you don't have a page footer, it fills the space available. If you have a report footer, and there are enough records to fill the first column without leaving room for the report footer, then it will be printed on the next page. What are your keep together settings for the headers/footer/detail?
    Charlotte

  9. #9
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report footer goes to next page (2007)

    Keep together settings:
    Report Header=Yes
    Detail=Yes
    Report Footer=Yes
    (I guess the page header and footer have no settings for "Keep Together?)

    Thanks again for you time and efforts on my behalf.

    Warren

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report footer goes to next page (2007)

    > I guess the page header and footer have no settings for "Keep Together?

    Correct. The page header and footer are kept together by definition - they are displayed on *each* page so it wouldn't make sense to split them over more than one page.

Posting Permissions

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