Crystal Reports What is the NVL formula used for ?

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

Topic: What is the NVL formula used for ?

Author	Message
sanur13 Newbie Joined: 25 Apr 2016 Location: France Online Status: Offline Posts: 18	Topic: What is the NVL formula used for ? Posted: 07 Mar 2017 at 10:48pm
	Hi everyone, I'm working on a report that was created by someone else and it has a formula that uses the NVL() fuction. What does that function do exactly? It goes like this: nvl(table.field,0) Thanks a lot, Santiago
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Mar 2017 at 2:49am
	Not familiar with this as a crystal function but I believe it is similar to a coalesce() or isnull() in SQL and it will, in your example, return a 0 when the table.field is null otherwise it returns the value from table.field.
	IP Logged

sanur13 Newbie Joined: 25 Apr 2016 Location: France Online Status: Offline Posts: 18	Posted: 08 Mar 2017 at 4:23am
	Thanks a lot, it's exactly what the formula's doing.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 24 Mar 2017 at 6:56am
	yes, NVL is Oracle IsNull. COALESCE is ANSI standard and works in both Oracle and SQL
	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.016 seconds.