Duplicate Pages in Summary Report

[Guest]

I seem to be having a similar problem that others are experiencing but the
responses on Duplicate Pages in reports are not correcting my problem.

In my report, all of the text boxes summarize (either by count or sum)
fields in the underlying query. Everything fits on one page but when
printed, it prints a page based on the number of records in the query. I
think this is because all of the text boxes are in the DETAIL section so,
naturally, the report will print whatever is in the detail for each record.

I don't want this to happen. I only need one page to print. How do I
accomplish this? I believe a report has to have a detail section but how to
I tell it to only print one page? Thanks.

 

[Terry]

Slej,

Shift your counts and sums etc. into the report footer
(not page footer) or into the relevent group footer. The
detail section can then be shrunk to zero height.

HTH,

Terry

 

[Guest]

That did it! Thank you so much Terry.

Slej,

Shift your counts and sums etc. into the report footer
(not page footer) or into the relevent group footer. The
detail section can then be shrunk to zero height.

HTH,

Terry