I have a purchase table and the fields are -:
pro_name,batch,exp_dt,drg_mfg,qty,mrp,pur_amt,pur_Date
I want it show in crystal report like this(Here pur_date may be duplicate)
pur_date
pro_name,batch,exp_dt,drg_mfg,qty,mrp,pur_amt
and sum(which show in every distinct pur_date details footer) of qty,mrp,pur_amt and also grand total(which show in report footer) of qty,mrp,pur_amt..
my problem is: when i create crystal report with group by clause with pur_date it shows like this
1/27/2013
all the records details with duplicate pur_dates...
I'm using it in winform...
Thanks for every help......