Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: how to supressing Null field replace other field Post Reply Post New Topic
Author Message
chanti
Newbie
Newbie
Avatar

Joined: 04 Jan 2010
Location: India
Online Status: Offline
Posts: 6
Quote chanti Replybullet Topic: how to supressing Null field replace other field
     Posted: 11 Jan 2010 at 9:56pm
  I have a problem with crystal reports. I am doing a project, in that i want supress zero field (ie., da=0) in that place i want show another field (ie., hra=300)
 
basic=5000     gpf=50
da=0               gis=85
hra=300          cca=250
 
i want show hra in place of da, I need this one. any one help me...


Edited by chanti - 11 Jan 2010 at 9:57pm
S.Jayaraj
IP IP Logged
flanman
Senior Member
Senior Member
Avatar

Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Quote flanman Replybullet Posted: 12 Jan 2010 at 8:31am
Create a formula for da as fallows:

If da > 0 = then da
else
hra

Put this formula in the report where you would normally put the
da field and you should be all set.
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.