Print Page | Close Window

Keep Summary with last record

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12819
Printed Date: 30 Apr 2024 at 10:32pm


Topic: Keep Summary with last record
Posted By: 00331data
Subject: Keep Summary with last record
Date Posted: 05 Apr 2011 at 12:34pm
Hi:
 
I have a report which needs a page break after each record.  I need to total the records, which I have done in the Report Footer.  But the problem is that the total ends up on a page by itself, instead of on the page with the last record.
 
Is there a way to insert the total on the last page that contains data?


-------------
thanks,
00331data


Replies:
Posted By: hilfy
Date Posted: 06 Apr 2011 at 3:41am

Go to the Section Expert.  Uncheck the checkbox and click on the formula button to the right of "New Page After".  In the formula enter this:

Not OnLastRecord
 
This will give you a page break for every record except the last one. 
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: 00331data
Date Posted: 06 Apr 2011 at 4:17am
Thank you!

-------------
thanks,
00331data


Print Page | Close Window