Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: formula field in crystal reports Post Reply Post New Topic
Author Message
gbalaji
Newbie
Newbie


Joined: 10 Jan 2011
Location: India
Online Status: Offline
Posts: 1
Quote gbalaji Replybullet Topic: formula field in crystal reports
     Posted: 10 Jan 2011 at 8:18pm
Hi,

I am using a formula field in crystal reports. I have to construct a formula for the following scenario, If ReasonC="PH" then count has to be displayed. However, if there are no rows with the above condition, query results NULL and formula field value is empty. I tried using IsNull function, but it seems i cannot apply the condition, ReasonC="PH" in IsNull condition. Is there any ways to construct formula for above condtion?

Thanks,
Balaji G
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 11 Jan 2011 at 2:42am
Does 'count' keep track of all of the records with ReasonC = "PH"?
I am unclear what you mean by

However, if there are no rows with the above condition, query results NULL and formula field value is empty


If you want to use the 'count' for records with the "PH" condition, you can just check whether it is satisfied.

Edited by Keikoku - 11 Jan 2011 at 2:43am
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.