Print Page | Close Window

If Statement

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10805
Printed Date: 28 Apr 2024 at 2:27pm


Topic: If Statement
Posted By: knaylor
Subject: If Statement
Date Posted: 11 Aug 2010 at 6:26am
I am trying to use an if statement to say "If (a field = "NQ") then return a different date field else leave blank. I wrote the formula like this:

If({ROTPersonnelStatusTableB.Type}="NQ") then {ROTPersonnelStatusTableB.Expiration Date} else " "

but I am getting an error saying that I need to have a date in the "else" section. Does anyone know a way around this?



Print Page | Close Window