Solved

Conditional Data Display in Crystal Report

Posted on 2012-03-24
3
502 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Macro update each line based on another worksheet 2 58
sql views 3 56
can this macro be converted to sub procedure 4 34
COM server issue 2 28
A short article about problems I had with the new location API and permissions in Marshmallow
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.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

751 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