Software

Ask something
Question Locked

set default value for database field in crystal report

0 helpful
2 replies

by amit_it15

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how i can set default value for the field having null value un database in crystal report ...

2 replies

by huoml

The better way would be to do it the SQL query/stored procedure you use to get the data to CR.

If I am not mistaken, you could also change the property of the field in CR and write your own two three liner that changes the value of the field being displayed.
something like
If db.fld1 is null default else db.fld1.

hth
-H

This discussion is closed to new replies.