How to write a formula in a crystal report using the formula editor

Question

I am using Crystal Report 2008 and I need to write a formula for the date parameter.

In some case, datetime will arrive at a null value from db. This time I need to show an empty space in the same reportld file. So, how can we write a formula for this using the crystal report formula editor

Thank you in advance

Answer 1

you can write sql codes as select isnull (datefield, ''), col1, col2 from the table ...