Solved

Conditional Data Display in Crystal Report

Posted on 2012-03-24
3
500 Views
Last Modified: 2012-03-24
I have a Report.
Data I am getting from table CKAmt.
In this report there is two fields.
1 - Amount.
2 - Mode.

Now What i want is,
if Mode is PAID then Amount should be ZERO.
ELSE Amount is whatever.
0
Comment
Question by:crystal_Tech
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 350 total points
ID: 37761058
Create a formula field as follows and add it to your report...

If {ckamt.Mode}="paid" then
0
else
{ckamt.amount}
0
 
LVL 1

Author Comment

by:crystal_Tech
ID: 37761154
Thanks Peter
Its working like charm. :-)
0
 
LVL 1

Author Closing Comment

by:crystal_Tech
ID: 37761156
Thanks for Quick Reply.
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question