Print Page | Close Window

Dates formatting

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12325
Printed Date: 09 May 2024 at 10:52pm


Topic: Dates formatting
Posted By: Zuzanna
Subject: Dates formatting
Date Posted: 15 Feb 2011 at 6:30am
Hi,
 
is there something in crystal formatting that can force a character into a date field if it null ? Ie. ######, so when I export to excel I will see #### in the cell instead of a blank ?
 
Thanks.


Replies:
Posted By: DBlank
Date Posted: 15 Feb 2011 at 6:46am
i think you would have to convert it to a string, something like:
if isnull(date) then "######" else totext(date,"MM/dd/yyyy")

Posted By: Zuzanna
Date Posted: 15 Feb 2011 at 7:04am
I know, thanks. We just converted from ver 9 to 2008 and we run these reports into excel. I still have the old ver. 9 report and there's no formula for that, although it has ### in excel. So I was hoping that it's some kind of a setting in crystal.

Posted By: DBlank
Date Posted: 15 Feb 2011 at 7:26am
might be how you have your NULL options set in the Report Options.
See if you set them differently between the versions.


Print Page | Close Window