Results 1 to 3 of 3
  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

    Page breaks in subreports (A97 SR2)

    O wise ones.

    I need your help on a tricky matter of page breaks and subreports. I know you Access does not recognise page breaks in subreports, and that you can set page breaks by grouping on a field. So here's the problem :

    1. I need a 3-column sub-report within a single column report. Have (nearly) solved that one by having 3 single column subreports within a larger subreport - all within the main report.

    2. This 3 single-column subreports may or may not spread across more than 1 page, and I need the column headings to repeat for each page. The reports are based on 3 queries which are generated at run-time. They split all the records into 3 sets, as equal as possible, e.g. for 76 records the sets are 1-26, 27-52, 53-76.

    3. Now what I need to do is to get the subreports to group on every 20th record (there is a RecordID in the query), and this is what I cannot get it to do.

    Any bright thoughts would be welcomed.

    Thanks

    Bodders

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

    Re: Page breaks in subreports (A97 SR2)

    1. If you can live with the records "across, then down" instead of "down, then across", you can use a three-column subreport. You wouldn't need to create 3 separate queries and 3 subreports.

    2. MSKB article ACC: How to Repeat Subreport Header at Top of Page may help.

    3. MSKB article ACC: Print Blank Line Every Nth Line in a Report (95/97) may help.

  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: Page breaks in subreports (A97 SR2)

    Hans

    Many thanks for that. It did not quite fit the bill, but I managed to find the answer in Stan Leszynski's wonderful book 'Access 97 Expert Solutions'. You have to set up a dummy group header section in the subreport with the column headings in, and a blank Report Header section. It then repeats the headings based on the page size, regardless of the number of records.

    Every serious Access developer should either have or read this book - there is so much good information in there, IMHO.

    Thanks again

    Nick

Posting Permissions

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