Print Page | Close Window

Formula help

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=19093
Printed Date: 06 May 2024 at 3:36pm


Topic: Formula help
Posted By: nitrotech
Subject: Formula help
Date Posted: 12 Feb 2013 at 11:56am
I need help with a formula
 
I have a report that creates an excel file that prints a hiredate and termination date
 
I do not want to print anything if there is no termination date  I want the cell to be Blank
 
Help Thanks
 


Replies:
Posted By: Sastry
Date Posted: 12 Feb 2013 at 6:17pm
HI

You can write a suppress condition for see the termination date cell blank.

Right click on termination date, go in format field-- Common--Suppress -- Formula editor and give the following :

if Isnull({terminationdate}) then true


-------------
Thanks,
Sastry


Print Page | Close Window