Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report page setting (A97 SR2)

    I have a layout problem with a report, which I hope someone can solve.

    The main report contains 2 subreports (Countries and Products), either of which may or may not appear, ie there can 0, 1 or 2 subreports. If either of them do appear I need to print a line of totals in a separate section below them. No problem so far.

    What I want to ensure is that when the second subreport (Products) appears it is printed on the same page as the totals, but sometimes the totals line is forced onto a new page. I can

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

    Re: Report page setting (A97 SR2)

    Do the subreports have a fixed size, or can they grow/shrink?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report page setting (A97 SR2)

    Hans

    They can both grow and shrink.

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

    Re: Report page setting (A97 SR2)

    Can you put the section containing the subreports and the section containing the totals line under a section spanning both? You could set the Keep Together property of the spanning section to Yes.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report page setting (A97 SR2)

    Hans

    This is a good idea, but did not work when I tried it. Both subreports can grow to most of a page, and so the whole section would then cover mutliple pages, and not guarantee that the total line & Product subreport would be on the same page.

    Bodders

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

    Re: Report page setting (A97 SR2)

    What actually is the reason for<blockquote><hr>I can

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report page setting (A97 SR2)

    I'm sure it's not you Hans - more the way I explained it.

    OK - the main report has some detail followed by 2 subreports, both of which are optional. If either of them have data, they appear, if not, they don't. If either of them does appear then a totals line is needed on the main report which gives totals for the subreports. The totals line can refer to either or both subreports, depending on whether they appear or not. If there is not enough space on the page the totals line appears - on its own - on the next page. This is what I want to avoid if at all possible. What I would like is for the second subreport to go together on the second page with the totals.

    I know it's all a bit tricky - I just wanted to find out if it could be done at all.

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

    Re: Report page setting (A97 SR2)

    But why does this preclude putting the totals line in the same section as the subreports? I still fail to understand that.

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report page setting (A97 SR2)

    Hans

    Thanks for bearing with me. Each subreport has its own total line which will appear if the subreport appears. If either (or both) of the subreports appear then an overall total line is needed on the main report adding up the total lines from the subreports. I don't want this overall total line to appear on its own on a page, if it can be avoided. The overall totals line cannot go in either of the subreports because there is no guarantee that they will appear.

    Bodders

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

    Re: Report page setting (A97 SR2)

    I think the best you can do is to put the second subreport and the totals line in a separate section - it might be an artificial section based on a dummy expression such as =1 - with Keep Together set to Yes.

  11. #11
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report page setting (A97 SR2)

    Hans

    You were completely right. Sorry it took me so long to twig on. Thanks again & have a great weekend.

    Bodders

Posting Permissions

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