Subreport Problem with totals

[dogpigfish]

I am in the process of combining a few independant reports into a single
report so they can all be in the same snp file. The problem I am having is
the totals on the bottom of each report seem to get off when I add them as a
subreport. The detail is correct, but it will double count a record (in the
subtotals) if it is cutoff into the next page. Any obvious reason this might
be happening?

Thanks in advance.

 

[Duane Hookom]

It sounds like you have totals in your page footer rather than report footer.
There are no page events, properties, or sections is subreports.

 

[Duane Hookom]

This sounds like you have placed your totals in the Page Footer. A subreport
doesn't have any page events, properties, or sections. You would need to use
a different section. Also, "double count" sounds like you are using code to
do something that normally doesn't require code.

 

[dogpigfish]

I appreciate the quick response:

I don't user page footers or headers when I merge subreports. These reports
have a report header and a report footer and a group by header and footer.
The first report has 4 pages which I think is the problem, so if the detail
gets split into the second page the subtotals may double count a record. The
detail section always comes out correct and there are no identical records
showing up. However, it double counts one or two of the records in the
subtotal (group by footer).

Is there a way to create a page break before or after a group of records and
their subtotal if they are going to split on a page? I set the "keep records
together" as yes, but it doesn't keep them together. This may be the wrong
control that I am looking for. Thanks.

 

[Duane Hookom]

I don't believe there is any way to create or use pagebreaks in subreports. I
don't think "keep records together" works well or at all in subreports. Maybe
Marsh is listenin' in and can provide some clarification.

 

[dogpigfish]

That's what I was afraid of. Thanks for the feedback.