Re: How set default value
- From: "Rob Blackmore" <rob@xxxxxxxxxxxxxxxx>
- Date: Fri, 5 Dec 2008 09:14:05 -0000
Hi,
this means that "nulls" will be replaced with the default value for that data type (e.g. 0 for numeric, "" for strings)
From crystal help
Convert Database NULL Values to Default
Select this check box to have the program convert null values from the database to a 0 (for numeric fields) or a blank (for non-numeric fields).
Note: This option affects only null values found in the database used for a report.
You cannot control what the "default" value will be. To do this you could use a function such as COALSCE in SQL Server to control what is returned from the database.
Kind regards
Rob
"clara" <clara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3195C6D0-FBC4-4090-9F6D-ECA2C4C2F5BE@xxxxxxxxxxxxxxxx
Hi all,
In the Default Settings Option dialog box and under the Reporting tab, there
is an option called "Convert Null to Default" . Does it mean a NULL can be
replaced by a preset value, if it is how it is done?
Clara
--
thank you so much for your help
.
- References:
- How set default value
- From: clara
- How set default value
- Prev by Date: Using default parameters in CR XI
- Next by Date: Default parameters in CR XI
- Previous by thread: How set default value
- Next by thread: Using default parameters in CR XI
- Index(es):
Relevant Pages
|
