Suppress printing of Subreport on the next page of the same group?

[Kevin T]

I am trying to print a summary page (subreport) followed by details. When it
overflow to the next page, I do not want the summary page to appear again for
the same group. How can I suppress printing of this report following a page
break?

I am pretty new to programming and I guess I need more details.

Thanks

 

[John Spencer]

Put the subreport in its own group section.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Kevin T]

I believe the subreport is already in its own group (VENDOR). The subreport
prints 1 line summary totals for each month, therefore it is variable
depending which month we are in. After printing the summary lines, i
continue to print the detail line for the current month. And this is another
variable number of lines. When it exceed the page, it goes to the next page
and it repeats all the header and so forth but the summary is printed again
at this break.

sample

------PAGE HEADER--------
COMPANY ABC
VENDOR 123

----VENDOR HEADER--------
SUBREPORT (BEGINS HERE)
SUMMARY LINE 1
SUMMARY LINE 2

-----DETAIL-----------
MAIN REPORT
DETAIL LINE 1
DETAIL LINE 2
DETAIL LINE ........

When a page break is encountered, it prints the VENDOR HEADER again. How can
I suppress that header again on the 2nd page forward for the same vendor.

Thanks

 

[John Spencer]

Change the Repeat Section property of the group to NO. That should work to
print the Vendor header only one time.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[derek]

I believe the subreport is already in its own group (VENDOR). The subreport
prints 1 line summary totals for each month, therefore it is variable
depending which month we are in. After printing the summary lines, i
continue to print the detail line for the current month. And this is another
variable number of lines. When it exceed the page, it goes to the next page
and it repeats all the header and so forth but the summary is printed again
at this break.

sample

------PAGE HEADER--------
COMPANY ABC
VENDOR 123

----VENDOR HEADER--------
SUBREPORT (BEGINS HERE)
SUMMARY LINE 1
SUMMARY LINE 2

-----DETAIL-----------
MAIN REPORT
DETAIL LINE 1
DETAIL LINE 2
DETAIL LINE ........

When a page break is encountered, it prints the VENDOR HEADER again. How can
I suppress that header again on the 2nd page forward for the same vendor.

Thanks

move the page header stuff to the report header which only print once
per report


------PAGE HEADER-------- ==> ------Report HEADER--------
COMPANY ABC
VENDOR 123