Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report/subreport Page break (Access 2003)

    I created a Report that has 5 sub reports(graphs) in the detail section.
    From the report menu the user can select which (sub)reports they want to see(any combination of the 5).
    Depending on the combination selected sometimes the subreport is split with the remainder showing on the next page.
    It never takes more than 2 pages to show all the reports and up to 3 reports will fit depending on the selection.
    All the Can grow and Can shrink properties are set to Yes.
    I tried to code a page break but I couldn't figure the logic for all the possible combinations that the user could select.
    Is there a detail hight property that can be used to insert a break if the detail section gets past a certain height?
    Or is there a better way to do this.
    Thanks,
    Scott

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

    Re: Report/subreport Page break (Access 2003)


  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report/subreport Page break (Access 2003)

    Thanks,
    I'll give it a try

Posting Permissions

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