Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi detail section need new page after

Status
Not open for further replies.

dtqui

Programmer
Sep 25, 2000
62
SG
Hi,

I have this report that is suppose to calculate the running total of 2 fields. Because some records might have additional information, I created "detail b" to print those. Problem now is if the page length is not enough to print the additional information on the same page, the running total sums the figure on the previous page twice.

Page Header section
Group Header #1 section
Detail A section (printing item infor, amounts, running total)
Detail B section (printing additional infor)
...

Eg.
last line on page 1 : (DR)$45 (Total)$1000
first line on page 2 : additional infor for last item on page 1
second line on page 2 : (DR)$50 (Total)$1095 ***

***this figure should be $1050 instead.

Any help is appreciated very much.
Thanks.
 
Keep detail A & B on same page. Go to "Selection Expert". For entire "Details" section, select "Keep Together". Both sections will stay on the same page hopefully keeping the running total correct.
 
Hi campsys,

Thanks for your reply. It really works. I only checked the "detail A" keep together, "detail B" keep together and that doesn't work. But once I checked the "Detail" keep together, it works.

Thanks a lot again! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top