Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

New Page After..

Hi,

I use formula 'New Page After' - OnLastRecord, in Group footer2.

I have grand totals in Group footer1, the last one.

Store Procedure brings two sections:  0-Euros and 1-Dolars.

With OnlastRecord on group footer2, the totals are display in a new page for Euros Section.

The last section Dolars works fine.

How can show the totals for Euros Section in the same page ?

Thanks!
0
linareso
Asked:
linareso
  • 3
1 Solution
 
ebolekCommented:
Can you explain better. You have two groups. One is dollar, second is euros???They seem like the same thing to me currency. What is in the group 2 and what do u wantto do
0
 
linaresoAuthor Commented:
Group2 are Subtotals, and it can be several of them.  

The details and their subtotals must be in a new page. (I use Format Section 'New Page After' Formula, and set 'not Onlastrecord')

When is time to put the grand total(group1) for a Currency, takes 'new page After' and display the grand total in a new page (Just for the first section Euros,  Dolars works fine due not onlastrecord ).  

I want to display the grand total(group1) in the same page that the subtotals(group2), for the first section.

Thanks!!!




0
 
mlmccCommented:
Try this as the new page after formula

Not OnLastRecord

Another idea - Use the NEW PAGE BEFORE formula for group 2 header
Formula
Not OnFirstRecord

mlmcc
0
 
mlmccCommented:
May have slved it.  

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now