Print Page | Close Window

Formatting on last record in a group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1927
Printed Date: 28 Apr 2024 at 12:08am


Topic: Formatting on last record in a group
Posted By: lorif747
Subject: Formatting on last record in a group
Date 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.


Replies:
Posted By: tconway
Date 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


Print Page | Close Window