Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sub Report (2000)

    Hopefully this is a simple question. My main report has sums in the report footer. I also put a subreport in the footer. My problem is that the sums for my main report are on the top of the next page with the subreport. If I put a page break after the sums and before the subreport then the sums go on a page by themselves. How can I get the sums to go with the main report that they belong to?

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

    Re: Sub Report (2000)

    First, check the Force New Page property of the report footer of the main report. It should be set to None.
    Next, check the Keep Together property. It should be set to No.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub Report (2000)

    Thanks Hans - worked perfectly.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub Report (2000)

    Another question. The subreport headings - if I put them in the page header, they do not show up. If I put them in the Report header, they show but they do not show on the second page. Is there a way to use the page header to show the column headers so the headers show on the second page?

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub Report (2000)

    Theres a general report property: Page Header - set it to All Pages, and then just put the column labels in the page header so they line up with your report columns.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Sub Report (2000)

    See <post#=444114>post 444114</post#>.

Posting Permissions

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