how to write formula in crystal report using formula editor

Question

I am using crystal report 2008 version and i need to write formula for a date parameter.

In some case datetime will come null value from db. That time i need to show a blank space in the same report fileld. So how can we write the formula for this using crystal report formula editor

Thanks in advance

Answer 1

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