Print a field if it is not NULL
Hello,
I have a simple report, but in the database the date field have sometimes the value 31/12/1899, this is the NULL value for a date of the VCL.
Now when the field have that value a want to print only spaces or nothing.
How can I do this ?
Can i put some code behond the report in designmode or must I put some code in my appliation.
Thanks for the help.
Jan
I have a simple report, but in the database the date field have sometimes the value 31/12/1899, this is the NULL value for a date of the VCL.
Now when the field have that value a want to print only spaces or nothing.
How can I do this ?
Can i put some code behond the report in designmode or must I put some code in my appliation.
Thanks for the help.
Jan
Comments
you can test for null in the expression portion of the function if you set engine option convert null to false.