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
Solved

Conditional Data Display in Crystal Report

Posted on 2012-03-24
3
501 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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…

838 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