Print Page | Close Window

Page Break on Group Footer not working?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22665
Printed Date: 28 Apr 2024 at 10:21am


Topic: Page Break on Group Footer not working?
Posted By: techsupport
Subject: Page Break on Group Footer not working?
Date Posted: 31 Aug 2018 at 8:11am
Trying to set a "page break" on Group Footer #4, however the DepartmentRecap info on the Group Footer with the Check Amount are showing on the employee page and then the details on the next page.

I have it set on New Page After the formula NOT OnLastRecord

Tried it just checking the New Page After also

Same results.

Not sure why the Group Footer line isn't staying together with the details on the next page?

I've also tried Keep Together



-------------
____________________
Thank you very much!


Replies:
Posted By: hilfy
Date Posted: 20 Sep 2018 at 5:29am
Where have you tried "Keep Together"? It needs to be on the Group AND the section.

When you use the formula "not OnLastRecord" are you also checking the New Page After checkbox? If so, uncheck it.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: techsupport
Date Posted: 20 Sep 2018 at 8:33am
I checked Keep Together in both Section AND Group

The NOT OnLastRecord doesn't seem to be working.

There are other formulas in the New Page Before in the 2x https://www.dropbox.com/s/mf2yawovmlq542k/PR_DataEntryAudit.rpt?dl=0 - PR_AuditReport

-------------
____________________
Thank you very much!

Posted By: hilfy
Date Posted: 20 Sep 2018 at 9:11am
Thanks for posting the report! This would have been much harder to diagnose without it!

Looking at the report, you do NOT need "formula =" in the formulas in the Section Expert - just leave the rest of what you have that evaluates to True or False.

Looking at what your formulas are doing, it looks like you want a new page before based on a set of conditions AND new page after based on a condition that is part of the set for New Page Before. Is that correct?

You've also got some overlap with fields in the Suppress formula. 

Suppress:  {@SortReportBy} <> "E" or {@Departments} = "N" or {PR_DataEntryAuditWrk.ReportSection} <> "A"



New Page Before:  {@SortReportBy} = "E" and {PR_DataEntryAuditWrk.ReportSection} = "B"



New Page After:  {PR_DataEntryAuditWrk.ReportSection} = "B" and NOT OnLastRecord


Because of the 'or {PR_DataEntryAuditWrk.ReportSection} <> "A"' part of the suppress formula, the section is going to be suppressed. If the section is suppressed, the "New Page Before" and "New Page After" will also be suppressed. Also, if you want the new page after only when the report section is B, if there will always be report sections that are after b, you don't need the "OnLastRecord" part of that formula because the report will never be on the last record when report section = "B".

-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: techsupport
Date Posted: 20 Sep 2018 at 9:55am
Yes on the New Page rather before or after, not sure.
Thinking it's New Page Before section that needs to be modified.

I've removed the New Page After formula as it's not really doing anything with or without it. Original is without anything here.

As you saw, in GF4, Department Recap (red font) displays at the end of each department. Although the details are showing on the next page. Can't figure out how to have the GF4 Department Recap info (red font) show at the top of the next page with the department recap details.

Not sure how to modify the formula so that GF4 shows at the top of the new page along with the details. The details are showing on a new page but that the GF4 info (in red font).

-------------
____________________
Thank you very much!


Print Page | Close Window