E
Erin
This request was posted back in 2005 by another user:
"I have a wonderful report designed, but I cant find any information on page
breaks to keeps "groups" or "summaries" together, and break the page after a
section footer. In other words in this report I am importing a list of
payables and I need each vendor's results to remain on the same page. If
there is not enough room on the current page then the condition would send
the results to a new page. Each vendor has a varying number of record"
Alan Browne responded with this:
"To force a page break after the Group Footer, set the section's Force New
Page property.
If you want to keep all the detail records with the group header and footer,
and then let the next group of detail records and header and footer fit onto
the same page if it can, but push it all to a new page if it won't fit, you
can achieve that by placing the group header and detail records and group
footer into a subreport. Put this subreport into (say) the Detail section of
your main report, and set the main report's Keep Together property to Yes."
I want to do the same thing with my report. My data is grouped by order
number. The data in the subreport looks ok, but when I run the report, the
data is duplicated by the number of lines in the order (if there are four
lines in the order, the order shows four times, etc.) I have the report and
subreport linked on the order number; I’ve tried adding other fields (date,
cost, etc) but it only makes it worse – the order gets split and grouped by
whatever field I use. What is causing the data to duplicate?
"I have a wonderful report designed, but I cant find any information on page
breaks to keeps "groups" or "summaries" together, and break the page after a
section footer. In other words in this report I am importing a list of
payables and I need each vendor's results to remain on the same page. If
there is not enough room on the current page then the condition would send
the results to a new page. Each vendor has a varying number of record"
Alan Browne responded with this:
"To force a page break after the Group Footer, set the section's Force New
Page property.
If you want to keep all the detail records with the group header and footer,
and then let the next group of detail records and header and footer fit onto
the same page if it can, but push it all to a new page if it won't fit, you
can achieve that by placing the group header and detail records and group
footer into a subreport. Put this subreport into (say) the Detail section of
your main report, and set the main report's Keep Together property to Yes."
I want to do the same thing with my report. My data is grouped by order
number. The data in the subreport looks ok, but when I run the report, the
data is duplicated by the number of lines in the order (if there are four
lines in the order, the order shows four times, etc.) I have the report and
subreport linked on the order number; I’ve tried adding other fields (date,
cost, etc) but it only makes it worse – the order gets split and grouped by
whatever field I use. What is causing the data to duplicate?