Crystal Reports On time delivery Missing dates, missing data.

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: On time delivery Missing dates, missing data.

Post Reply

Post New Topic

Author	Message
jaykav99 Newbie Joined: 07 Apr 2009 Online Status: Offline Posts: 14	Topic: On time delivery Missing dates, missing data. Posted: 27 Jan 2010 at 9:07am
	I am trying to get a percentage of on time orders. So basically if the ship date is bigger than the required date we missed our deadline. But the same is true if the order still has no ship date at all. Crystal is ignore blank dates and giving me 100% on time delivery. How do i get crystal to read the blank date field.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 02 Feb 2010 at 11:16am
	IN your formula use an OR statement for inclusion. Not knowing your data here is a example guess: {table.ShipDate}>{table.Requireddate} OR isnull({Table.shipdate}) Or possibly, in the formula editor change your option from "Exceptions for nulls" to use "Default Values for Nulls" Edited by DBlank - 02 Feb 2010 at 11:18am
	IP Logged

Printable version

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