Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Suppress Footer for the last record of a group Post Reply Post New Topic
Author Message
kjoguth
Newbie
Newbie
Avatar

Joined: 30 Dec 2009
Location: United States
Online Status: Offline
Posts: 3
Quote kjoguth Replybullet Topic: Suppress Footer for the last record of a group
    Posted: 30 Dec 2009 at 11:22am
I feel like this should be a fairly simple thing, but I can't seem to figure it out or find documentation anywhere.
 
I have created a report with several groups.  I have placed a line in the footer of one of the groups that I would like to suppress on the last record of each group.  Can this be done?  Any assistance is greatly appreciated!


Edited by kjoguth - 30 Dec 2009 at 11:26am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Dec 2009 at 11:34am
move it to its own section and conditionally suppress the section with :
onlastrecord or next(table.groupfield)<>table.groupfield


Edited by DBlank - 30 Dec 2009 at 11:36am
IP IP Logged
kjoguth
Newbie
Newbie
Avatar

Joined: 30 Dec 2009
Location: United States
Online Status: Offline
Posts: 3
Quote kjoguth Replybullet Posted: 30 Dec 2009 at 11:41am
onlastrecord only suppresses the footer for the last record on the report.  I need to suppress it for the last record of each group.   Sorry, I'm not following your reference to table.groupfield. 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Dec 2009 at 11:51am

whatever field your are grouped (that you want to suppress on the last record for this group level) on use the next() function. This evaluates to see if the next rows value = the current rows value.

onlastrecord or next({table.field})<>{table.field}
 
e.g.
GH1 (using Customer.ID as group)
GH2(using Sales.No as group)
Details
GF2 - has line drawn on it
        conditional suppression using the formula 
        onlastrecord or next({customer.ID})<>{customer.ID}
GF1


Edited by DBlank - 30 Dec 2009 at 12:35pm
IP IP Logged
kjoguth
Newbie
Newbie
Avatar

Joined: 30 Dec 2009
Location: United States
Online Status: Offline
Posts: 3
Quote kjoguth Replybullet Posted: 30 Dec 2009 at 1:15pm
Got it!  That worked perfectly!  Thank you very much!
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.031 seconds.