on 04-26-2018 9:56 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhilash,
it works perfectly!
Thank you very much.
Beppe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.