cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report print null date as 30/12/1899

beppe1964
Explorer
0 Kudos

Hello to all, I have developed a report with Crystal Report for Visual Studio (2017). The data source of my report is a SqlServer table that contains some columns of data type (non-datetime, date only). When the date column contains the NULL value, the report prints me 12/30/1899!

I want you to print me an empty string.

Where am I wrong ???

Thank you very much.

Beppe

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor

Hi Giuseppe,

I've seen this behavior with SQL Server, however, for me even SQL Server Management Studio prints 1899!

CR does not transform NULL to a default date value. Could you please run a simple query in the database and search for rows with year = 1899.

If you still wish to suppress such values, right-click the field > Format Field > common tab > Click the formula button beside suppress and use this code:

Year({Date field}) = 1899

-Abhilash

Answers (1)

Answers (1)

beppe1964
Explorer

Hi Abhilash,

it works perfectly!

Thank you very much.

Beppe