Software

Question

Gravatar
0 Votes
Locked

set default value for database field in crystal report

By amit_it15 ·
how i can set default value for the field having null value un database in crystal report ...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Default values in Crystal Report

by huoml In reply to set default value for dat ...

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

Back to Software Forum

Start or search

Related Discussions

Related Forums