Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null To Zero

Status
Not open for further replies.
Smithsc

Smithsc

MIS
Apr 20, 2007
143
GB
Is there a function in Crystal which works the same as the NZ function in MS Access?
 
Sort by date Sort by votes
You can go into file->report options and select "convert null to default values". Otherwise you have to convert in a formula:

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

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
391
AleXSR700
AleXSR700
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
472
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
303
jchewsmith
jchewsmith
jlr123
  • Locked
  • Question
If field is Null 1
Replies
3
Views
209
kray4660
kray4660
Corinne30
  • Question
Running total based on beginning parameter value
Replies
0
Views
93
Corinne30
Corinne30

Part and Inventory Search

Sponsor

Back
Top