Crystal Reports How to count number of records showing 0 qty

Technical Questions

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

Topic: How to count number of records showing 0 qty

Author	Message
mjay83 Newbie Joined: 02 Aug 2007 Location: Malaysia Online Status: Offline Posts: 3	Topic: How to count number of records showing 0 qty Posted: 02 Aug 2007 at 4:28am
	I got 3 groups in my crystal report with few records with 1 field name QtyOrdered How do I calculate number of records with QtyOrdered= 0 and show it in the end of each group I written out the formula as: Numbervar Zero; if {StockOnHandOrderPlaced.QtyOrdered} = 0 then (Zero:=Zero+1) It calculating all records which is not according to groups, how do i change the formula so it can calculate group's record?
	IP Logged


BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 02 Aug 2007 at 7:25am
	Create a second formula: Numbervar Zero; Zero := 0; Place this in the Group Header section to reset the running total. You can suppress it so that it isn't printed and it will still be calculated.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 02 Aug 2007 at 2:12pm
	The other way I do these is with a formula like this: If {StockOnHandOrderPlaced.QtyOrdered} then 1 else 0 I then do a sum of this formula at whatever group level I need it. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 02 Aug 2007 at 9:49pm
	Ah yes. Good idea.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

mjay83 Newbie Joined: 02 Aug 2007 Location: Malaysia Online Status: Offline Posts: 3	Posted: 02 Aug 2007 at 9:57pm
	Thanks for replies from BrianBischof and hilfy, i change my formula to If {StockOnHandOrderPlaced.QtyOrdered} = 0 then 1 else 0 and put it into details And put a sum of the formula in the end of each group and it works perfectly, Thanks!!
	IP Logged

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