crystal reporting in vs2008

Posted by hatem gamil on Stack Overflow See other posts from Stack Overflow or by hatem gamil
Published on 2010-03-21T11:45:33Z Indexed on 2010/03/21 11:51 UTC
Read the original article Hit count: 319

Filed under:

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

Related posts about crystal-reports