Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Page Break on Group Footer not working? Post Reply Post New Topic
Author Message
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Topic: Page Break on Group Footer not working?
    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!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet 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 PR_AuditReport
____________________
Thank you very much!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet 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!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.