Solved

CRYSTAL REPORTS:  Add If blank value then "No Contact made"

Posted on 2011-03-16
4
406 Views
Last Modified: 2012-05-11
Experts,

How would I write a statement in Crystal 2008 that for a column named "Called_Start_Time" would replace any nulls with "No Contact Made"?  Where and how would I write this statement?

I have attached the file.. Change-Control-Maintenance-Repor.rpt
0
Comment
Question by:Maliki Hassani
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 35152346
Too do this you need a formula like

If IsNull({Called_Start_Time}) then
   "No Contact Made"
Else
   CStr({Called_Start_Time},"dd-MMM-yyyy")

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35152382
Look at the attached report

mlmcc
Change-Control-Maintenance-Repor.rpt
0
 

Author Comment

by:Maliki Hassani
ID: 35152864
Okay thanks check it out in an hour!
0
 

Author Closing Comment

by:Maliki Hassani
ID: 35153220
Thank you
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

679 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