New Page After..

Posted on 2004-10-06
Last Modified: 2008-03-10

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 ?

Question by:linareso
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 10

Expert Comment

ID: 12242536
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

Author Comment

ID: 12243281
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.


LVL 100

Accepted Solution

mlmcc earned 135 total points
ID: 12245236
Try this as the new page after formula

Not OnLastRecord

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

LVL 100

Expert Comment

ID: 12454726
May have slved it.  

LVL 100

Expert Comment

ID: 12469780
Glad i could help


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question