Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula Help Needed, If Then Else? Post Reply Post New Topic
Author Message
belfane
Newbie
Newbie


Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
Quote belfane Replybullet Topic: Formula Help Needed, If Then Else?
     Posted: 30 Aug 2016 at 4:12am
Hi all,

I'm looking for help on a formula.

if {SO_Detail.Price} <> than the original price then show {SO_Detail.Product} else suppress duplicate {SO_Detail.Product}

For example, when the column to the right (price) changes I want the number on the left (Product) to repeat, otherwise stay suppressed:



Edited by belfane - 30 Aug 2016 at 5:11am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Aug 2016 at 3:52am
Make sure to set the suppression formula to use default values for nulls and try

table.rightfield = previous(table.rightfield) and table.leftfield = previous(table.leftfield)
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.