×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Page Break on Group Footer not working?

Page Break on Group Footer not working?

Page Break on Group Footer not working?

(OP)
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

https://res.cloudinary.com/engineering-com/image/upload/v1535739409/tips/Audit_hlwllv.bmp

https://files.engineering.com/getfile.aspx?folder=...

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

(OP)
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

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

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

-LB

RE: Page Break on Group Footer not working?

(OP)
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/getfile.aspx?folder=...

RE: Page Break on Group Footer not working?

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

-LB

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

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

RE: Page Break on Group Footer not working?

(OP)
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

RE: Page Break on Group Footer not working?

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

-LB

RE: Page Break on Group Footer not working?

(OP)

Quote:

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

RE: Page Break on Group Footer not working?

That is not what I meant. I should have said conditional selection instead of suppression.

Look at the formulas you are using to display results in the Group 7 footers, where you conditional select a running total based on a report section A, B, C. This is what is complicating the report. I think you should at least remove the references to C, and instead put the "C" running totals in the Group #1 Footer. You can copy the row labels in the Group 7 footer section into the Group 1 Footer, to make this a quicker process. Place the "C" running totals directly into this section, without embedding them in a formula.

I'm guessing you didn't design this report yourself.

-LB

RE: Page Break on Group Footer not working?

(OP)
Ok, I'll try to do what you stated here to best of my knowledge.

Thank you

That is correct. RE: I did not create the report.
It's an out-of-the-box by the software program they use and requested these changes.

RE: Page Break on Group Footer not working?

(OP)
I copied the GF7 a,b,c to the GF1
I copied the conditional formula from those over to the GF1 and on the related fields
I copied the GH1 to GF1
I suppressed GH1 and copied the conditional formula to GF1 on the related fields

Ok, it's not working.
Obviously it could be what I did or did not do correctly

RE: Page Break on Group Footer not working?

That wasn’t what I suggested. I’m sorry but I don’t think we are communicating well enough for me to be of assistance.

-LB

RE: Page Break on Group Footer not working?

(OP)
I believe I did what you had stated?

I Cut the Running total labels from Group Footer 7c to Group Footer 1
It's not working
The Deductions Total shows on the 1st page of the ReportRecap and on the last page but the Deduction detail still shows on separate pages

Quote:


I think you should at least remove the references to C, and instead put the "C" running totals in the Group #1 Footer. You can copy the row labels in the Group 7 footer section into the Group 1 Footer, to make this a quicker process. Place the "C" running totals directly into this section, without embedding them in a formula.

RE: Page Break on Group Footer not working?

You need to undo the conditional field suppression formulas on everything you copied over for one thing. Not sure why you suppressed the GH1.

-LB

RE: Page Break on Group Footer not working?

(OP)
I unsuppressed GH1 and removed the conditional field suppression formulas

The Deductions, which are in Details a and sometimes in Details m, that are showing on separate pages on most of them, whereas the Earnings are showing together on a page.

ReportRecap pages 11-16 (last page is just the ReportRecap total repeated by itself.

Wouldn't a change or changes need to be made at the section that it's showing the data the way they are, separate pages per Deduction in Details a?

RE: Page Break on Group Footer not working?

(OP)
UPDATE:

setting the original formula back "on" keeps the ReportRecap as one page
This is on the New Page Before 2x section

Quote:


' 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

formula = {@SortReportBy} = "E" and {PR_DataEntryAuditWrk.ReportSection} = "B"

By doing so, back to the DepartmentRecap GF4 shows after the last employee for each department and the details on the next page. Which is good BUT need to have the Title that's in the GF4 DepartmentRecap line.
I set GF4 to Print On Bottom of Page so the recap details stay together. But as noted, the GF4 shows on the bottom of the last page of the last employee in the department.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close