Solved

# New Page After..

Posted on 2004-10-06
Medium Priority
214 Views
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
Question by:linareso
[X]
###### 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
• 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
0

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.

Thanks!!!

0

LVL 101

Accepted Solution

mlmcc earned 405 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
Formula
Not OnFirstRecord

mlmcc
0

LVL 101

Expert Comment

ID: 12454726
May have slved it.

mlmcc
0

LVL 101

Expert Comment

ID: 12469780

mlmcc
0

## Featured Post

Question has a verified solution.

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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
###### Suggested Courses
Course of the Month10 days, 22 hours left to enroll