Page Break on Group Footer not working? 1

[supportsvc]

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

[URL unfurl="true"]https://res.cloudinary.com/engineering-com/image/upload/v1535739409/tips/Audit_hlwllv.bmp[/url]

https://files.engineering.com/getfi...82f4-0f9c5d4a1da1&file=Audit_GroupFooter4.JPG

 

[lbass]

In the group expert, do you have “Keep Group Together” checked for whatever group you are having the problem with?

For help, you need to identify the names of all groups (your attachments don’t show any sections labeled) and explain in a little more detail what is happening and then also how the report SHOULD display.

-LB

 

[supportsvc]

Yes, noted that I tried the Keep Together and that is on the Group Footer 4

Here's the .rpt

https://files.engineering.com/getfi...-bda5-e349d3fb8a6f&file=PR_DataEntryAudit.rpt

 

[lbass]

That “Keep Together” only keeps the group footer section together. Go to the report->group expert->select the group and check “Keep Group Together”. Then if that doesn’t work, I’ll look at your attachment further.

-LB

 

[supportsvc]

Thanks it's also on the Group Expert section as well

I've also tried with the New Page After checked in the Group Expert. No difference


Thank you

 

[lbass]

Still can't tell what the problem is, and I can't tell when the report is not saved with data. I need to know what the report SHOULD look like, too. Please describe that, and send the report with saved data, removing any confidential info).

I noticed you have page after set on the group #4 header and you also have formulas set up for BOTH new page before AND new page after for the group #4 footer. So you would have a page break after the header (before the details) as well as after the details/before the group footer as well as after the group footer. Is this your intention? Note that when using a conditional formula to format a section, it is generally best not to also check the condition. The formula will apply even when the condition is unchecked.

For further help you need to send the report with saved data.

-LB

 

[supportsvc]

See print out here:

https://files.engineering.com/getfi...-bc92-aab15ea507aa&file=PR_DataEntryAudit.pdf

The DepartmentRecap title should be at the top of page 2

 

[lbass]

You didn't respond to my last requests.

I did notice that your conditional formula for new page before on the GF4 footer will not work because the embedded "Sort Report By" is set to "", while the formula calls for a value of "E".

-LB

 

[supportsvc]

I didn't it would save data since it uses a Work table (generates only when using the db system it's connected to)

So I ran it in the program then exported as Crystal Reports

See attached

https://files.engineering.com/getfi...-89ed-a98f7f7cc569&file=PR_DataEntryAudit.rpt

I removed the New Before formula, same results.

 

[lbass]

I can't follow this well enough to provide the full solution, but I can maybe get you partway there.

First, remove the "Keep Group Together" on Group #4 in the group expert->options.

Remove "New Page After" on the Group Header #4.

Remove "New Page After" on the Group Footer #4.

Add "New Page Before" on Group Footer #4.

Then the problem is that the GF4 repeats above the employee details, so you might have to add a formula to suppress the GF4, like (in Crystal syntax):

{@DepartmentRecap}<>next({@DepartmentRecap})

This seems to work, except there are appear to be some "straggler" detail records at the end with a repeating dept recap--not sure why. Maybe you know.

-LB

 

[supportsvc]

Thank you

Looks like the DepartmentRecap line is showing on a new page, however it needs to combine it with the 3rd page as the title of the 3rd page.

How do you do that to make that occur?

 

[lbass]

You must not have removed all the items I mentioned. Please double check.

-LB

 

[supportsvc]

Ah, had to check both Section Expert AND in Change Group section

Thank you!

How do I keep the ReportRecap together? It has a last page of the Group title with the Check Amount Total

Group 1

https://files.engineering.com/getfi...-b930-89ad8d8f957f&file=PR_DataEntryAudit.rpt

 

[lbass]

If you look at the section names on the left, what section is appearing after the page header?

-LB

 

[supportsvc]

Group 1 is the ReportRecap

Please see attached

 

[lbass]

Are pages 8-14 all supposed to be on the same page (final page)? Or are you saying only that page 14 should not appear?

-LB

 

[lbass]

Using conditional suppression in order to avoid a separate summary section has made this report overly complex. I would instead remove the report recap running totals from your conditional section suppression formulas and place them in the GF1 section. You can copy all the text from the previous summary section, etc.

-LB

 

[supportsvc]

Yes, the Report Recap Group 1 should be all together not separated. So yes, starting from page 8.

I removed New Page Before on Selection Expert section
The Report running totals is on Employee Section Group 7

 

[lbass]

Please change the report so that the report recap figures are in the GF1 section as I suggested in my last post.

-LB

 

[supportsvc]

remove the report recap running totals from your conditional section suppression formulas and place them in the GF1 section. You can copy all the text from the previous summary section, etc.

So this is what I did
1) Removed the conditional suppression formula in GH1 (Selection Export | Suppress | 2x | //the forumula
2) Copied this formula to GF1 and placed it like it was in GH1
3) I am not understanding the last part to "copy all the text from the previous summary section, etc."
They are Deductions and the running totals are set in the Employee sections GF7

It has this in the formula notes:
' Report Section A = Employee/Check
' Report Section B = Department Recap
' Report Section C = Report Recap
' Employee Section 1 = Earnings Detail
' Employee Section 2 = Allocated Tips
' Employee Section 3 = Deductions Detail
' Employee Section 4 = Tax Detail
' Employee Section 5 = Employer Contribution Detail
' Employee Section 6 = Direct Deposit Detail