Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: "New Page After" except for last page in GF2 Post Reply Post New Topic
Author Message
ajmufic
Newbie
Newbie


Joined: 28 Aug 2008
Online Status: Offline
Posts: 20
Quote ajmufic Replybullet Topic: "New Page After" except for last page in GF2
    Posted: 28 Jul 2011 at 9:38pm
Hi All,
 
I have a report showing information grouped by Month, Week and Day. Like this:
GH1: Month
  GH2: Week
    GH3: Day
      Details...
    GF3: ---
  GH2: Summary of Week (THIS IS WHERE I WANT THE PAGE BREAK)
GH1: Summary of Month
 
I want to have a new page after each week, except after the last week (page) of a period, because I have a summary in the GF1 and it ends up on an empty page if there is a page break before it.
 
I tried to use "NOT OnLastRecord" but it only works for the last record, in the last week of the last month.
Is there some kind of "OnLastRecordOfGroup"?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 29 Jul 2011 at 3:04am
not knowing more than what you have mentioned, I would check if the next record matches the grouping criteria for GH1.  If the next record does not match, then I would suppress the New Page Before.
 
Something like this in the New Page Before x-2 button
Next({table.group1Field}) = {table.group1Field}
 
 
this will return true for all members of the same group, and so you will get the page break.  On a new group (or last record of the current group), it will return false and suppress the page break.
 
HTH
 
 
IP IP Logged
ajmufic
Newbie
Newbie


Joined: 28 Aug 2008
Online Status: Offline
Posts: 20
Quote ajmufic Replybullet Posted: 29 Jul 2011 at 4:50am

Thanks for your reply lockwelle.

It guided me to the solution. Thanks a lot!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.012 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.