counting fields based on group in crystal report
Posted
by hatem gamil
on Stack Overflow
See other posts from Stack Overflow
or by hatem gamil
Published on 2010-03-21T14:47:11Z
Indexed on
2010/03/21
14:51 UTC
Read the original article
Hit count: 330
crystal-reports
hi all i wana ask a question about crystal reporting in vs 2008
lets say i have a report with these data
customer_ID Customer_Name Order_amoont Order_Date (#group1 VipCustomer) 1 xyz 3 1/1/2010 2 abc 4 2/2/2010 5 sds 21 3/12/2009 (#Group2 NormalCustomer) 3 tyt 2 3/3/2010 4 ha 4 21/3/2009
i want only to display records where Order_Date year is in 2010 only so i went to the section expert and i added a condintion in suppress formula Year(order_Date)=2010 and i get the result ,,the question is how to count how many vip customers ordered in 2010 only and how many normal customer order in 2010 only ,,then i want the total number of both type of customers to be displayed to have a report like that:: customer_ID Customer_Name Order_amoont Order_Date
(#group1 VipCustomer) 1 xyz 3 1/1/2010 2 abc 4 2/2/2010 subtotal 2
(#Group2 NormalCustomer) 3 tyt 2 3/3/2010 subtotal 1
total 3
thnx
© Stack Overflow or respective owner
