Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pagination with subreports (Acc 97 SR2)

    I have a report which prints details for each selected customer (address, city, etc). The Detail section contains two subreports -- one that prints deliveries to the customer, and one that prints "service quality events" for the customer. The report works exactly as required when there are just a few records in each of the delivery or service tables.

    The problem occurs when there are enough records in either of the subordinate records for it to occupy more than the remaining space on the page. In this case, Access leaves the remainder of the page blank and starts printing the subreport on the subsequent page. What I sometimes end up with is one line at the top of a page (customer name and address), blank for the remainder of the page, and the subreport printing on the subsequent page.

    The only settings I have altered is the CanGrow and CanShrink of both subreports are set to True. Is there a setting I am overlooking to force the subreport to start printing on the current page even if there is insufficient space to complete the printing?
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pagination with subreports (Acc 97 SR2)

    Hi

    I think the answer is click on the detail section of the main report to display properties. Then under format select No for keep together.

    Regards
    WTH

Posting Permissions

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