Print Page | Close Window

Remove the Low Value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=316
Printed Date: 03 May 2025 at 2:24pm


Topic: Remove the Low Value
Posted By: wkresearch
Subject: Remove the Low Value
Date Posted: 13 Mar 2007 at 3:02pm

Is there a way to remove the last line of a Crystal Report by Group.  I’m trying to remove the lowest score on a report.  I created a formula where @Score <> minimum(@Score), but if I have more than one score that is the same and the minimum, then it removes all of them and I only want one removed. So, I am hoping I can sort in descending order and remove the last line.  Any ideas?


Replies:
Posted By: BrianBischof
Date Posted: 13 Mar 2007 at 3:16pm
You can use the Suppress property with Crystal functions to disable the last line in the group. There is the OnLastRecord() function, but I think that only applies to the whole report and not the group (but you should check it out in case I'm wrong). You can also look at the function Next(field) which tells you the value of the next field. Use it with the grouping field and suppress it when the next field is not equal to the current field value.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window