Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Remove the Low Value Post Reply Post New Topic
Author Message
wkresearch
Newbie
Newbie


Joined: 13 Mar 2007
Location: United States
Online Status: Offline
Posts: 1
Quote wkresearch Replybullet Topic: Remove the Low Value
    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?

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
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.