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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report group break problem

Status
Not open for further replies.

GShen

MIS
Sep 26, 2002
561
US
Hi,
I have a report which currently breaks on a facility which is either set to 1,2 or 3. I want to page break after facility 1 only and group 2 and 3 together as subbreaks, so I added another field and have facility 1 set to a 1 and facility 2 and 3 set to a 2. I put this field in the high order group break and on the group footer I perform a FORCE NEW PAGE AFTER SECTION.
Everything is perfect except that I have a report footer that now does a page break because of the FORCE NEW PAGE AFTER SECTION.
Is there a way to stop the FORCE NEW PAGE when my value is 2 (Eg. last break on report)? I looked at the ON FORMAT or ON PRINT but I am not too sure what do with it.

Thanks,

If I confused anyone, I will clearify. It always sounds clear when the person writting it,reads it.

Remember when... everything worked and there was a reason for it?
 
This must have been confusing because nobody answered. I solved my own problem. I took out the footer break and added the FORCE NEW PAGE AFTER SECTION on the header. Works fine.

Remember when... everything worked and there was a reason for it?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top