Home » questions » How can I display empty value in similar dates in a datetime field in CrystalReport 9 connected with

How can I display empty value in similar dates in a datetime field in CrystalReport 9 connected with

2
2006-08-11 23:38:25, Category: Programming & Design
I have a database in SQL server 2000 where a datetime field shows 1/1/1900 in the null values. Now I don't want to display this 1/1/1900 in the crystal report 9.0. How can I show "-" or empty values instead of 1/1/1900 and the other remaining values cannot be changed?

Answers

  1. weida

    On 2006-08-13 00:00:37


    You may use the access query tool "Advanced Access Builder" at http://www.download5000.com/page25449.aspx or http://www.dlkj.net/sqlBuilder , it allows you to visually build complete SQL scripts.

  2. © 2006. Sammy Z.

    On 2006-08-13 00:55:26


    In Crystal design-mode, right-click the field and select field formatting. Add a logical formula under the suppression section that says: if {table.field} = "1/1/1900" then true else false My syntax for the null-date may be wrong, but you can work that out. I'm at home, and don't have Crystal running. IM me if you need help.