Crystal Reports Input a zero if field is null

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Input a zero if field is null

Author	Message
wallis34 Newbie Joined: 08 Nov 2007 Location: United States Online Status: Offline Posts: 1	Topic: Input a zero if field is null 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
	IP Logged

saoco77 Senior Member Joined: 26 Jun 2007 Online Status: Offline Posts: 104	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
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.