Page breaks in subreports (A97 SR2)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote