Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Formatting on last record in a group Post Reply Post New Topic
Author Message
lorif747
Newbie
Newbie


Joined: 24 Jan 2007
Online Status: Offline
Posts: 5
Quote lorif747 Replybullet Topic: Formatting on last record in a group
    Posted: 21 Dec 2007 at 11:56am
I have a balance sheet with four Account groupings.  The detail section prints the account description and balance.  I need to format the balance field so that if it is the last record in the group it has a single line for a bottom border.  I tried onlastrecord as a formula for the bottom border but that was no kiddin the last record on the report, not the last record in the group.  Is there a way to achieve this?  Thanks.
IP IP Logged
tconway
Newbie
Newbie
Avatar

Joined: 25 Dec 2007
Location: United States
Online Status: Offline
Posts: 20
Quote tconway Replybullet Posted: 25 Dec 2007 at 3:44pm
Try something like this
 
If Next({Orders.Customer ID}) <> {Orders.Customer ID}
    Then crSingleLine
Else
    crNoLine
 
 
...it will put a bottom border on the field where it's added to the Bottom Border X2.  Change the field name to match your Account Number. 
 
If this is not what you were looking for post again.
 
thanks
 
Tim
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.