bherring87
Technical User
When a date on our esso database is blank, Crystal uses 12/31/99. Is there any way to load this date into Crystal as the blank that exist on the database?<br><br>Your help will be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Conversion
- Thread starter bherring87
- Start date
- Status
In Crystal Reports Designer there is an option on the Report-Options menu:<br>'Convert NULL Field to Default'<br><br>If this option is ticked then un-ticking it may resolve the problem, but beware, it may mess up other fields on your report.<br><br>If blank dates still appear as 12/31/99 then go to the offending field, left click and select 'Format-field Common',<br>and create a formula via the 'Suppress' formula button:<br><br>isnull({field})<br><br>This should suppress the field whenever it is blank.
- Status
Similar threads
- Locked
- Question
- Locked
- Question