Crystal Reports Date/Time Suppression

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Date/Time Suppression

Page of 2 Next >>

Author	Message
south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Topic: Date/Time Suppression Posted: 19 Sep 2012 at 8:56am
	I have added a date/time field and text box in the report I am working on. I would like to suppress the text box when there is no date/time. I have tried the format editor - common tab - suppress - and used a formular to suppress if there is no date. It does not work! Yet no date is listed on the date field. ??
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 19 Sep 2012 at 9:02am
	the supression formula would be something like: isnull({table.datetime}) that should do it HTH
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 19 Sep 2012 at 9:20am
	I already tried that...it doesn't work.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 19 Sep 2012 at 10:13am
	are these all on the same detail row or are you doing summary level checking? is it really a datetime field or a string that is formatted like datetime? Edited by DBlank - 19 Sep 2012 at 10:19am
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 19 Sep 2012 at 8:50pm
	Hi.. In suppress formula editor.. On top middle there is drop down box, choose Default values for Null and make the following change in your formula : isnull(table.field) or {table.field} = " "
	Thanks, Sastry
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 3:15am
	I have it in the group editor and it is a datetime field. There must be some kind of default date but when I look in the table that the information is coming from it's blank. I can not believe something that I thought would be so easy ends up being so difficult!
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 3:18am
	I did the formula and it says that there is an error in the formula - i highlights "" and says a datetime is required here.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 3:40am
	What do you mean by "I have it in the *group editor*'?
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 4:02am
	Sorry...I meant I have it in the group header not in the detail section of the report.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 4:19am
	The formula you wrote evaluates per row (detail section). Since you are palcing it in a group header it is only evaluating for the first row in the group. try to do some trouble shooting make a formula field as lockwelle suggested usingh isnull({table.datetime}) place it on the detail section it should return True (if the fiel sis null) or False (if the field has a value). Is this working as you expect?
	IP Logged

Page of 2 Next >>

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum