I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then it must be returned with a value I have specified.
IsNull({myField},0) or
IsNull({myField},'Hello World')
I have encountered that I have to create a separate function for number fields and a separate function for text fields. I also found that Crystal does not allow the use of standard functions inside of a custom function, for instance the ISNULL
Function:
Function(NumberVar param, Numbervar setter)
IF ISNULL(param) THEN setter ELSE param
and
Function(StringVar param, StringVar setter)
IF param = NULL THEN setter ELSE param
Does anyone know how I can create a function like this in Crystal and a work around for the ISNULL
inside of a custom function?
IIF and IsNull are functions in Crystal Reports that are used in formulas to test fields for blanks, empty strings, missing values and NULL, then return some valid output. This is especially helpful when preparing a report, since these values can cause blank lines to be printed.
If value isn't null, your code should put it into the shared variable. If it is null, your code can safely ignore it and do nothing.
You can't pass a null value into a custom function, so it's pointless to use crystal's isnull
function inside one. Only option is to write it like...
if isnull({myField}) then 0 else {myField}
I found this issue, in the formula editor there is a drop down in the header that indicates:
Select the second one ( Default values for nulls)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With