Print Page | Close Window

Input a zero if field is null

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1649
Printed Date: 29 Apr 2024 at 5:46pm


Topic: Input a zero if field is null
Posted By: wallis34
Subject: Input a zero if field is null
Date Posted: 08 Nov 2007 at 6:56am

I am sure this is a total noob question but how do you get a zero "0" input in a crystal 8.5 report in a field where the query is null?



-------------
Bill Allis
IT Admin
Lighting Services Inc.
www.lightingservicesinc.com


Replies:
Posted By: saoco77
Date Posted: 08 Nov 2007 at 7:31am
Create a formula that looks something along these lines:

if isnull({table.fieldname}) then 0 else {table.fieldname}


Sarah


Print Page | Close Window