Click here to Skip to main content
15,664,272 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a purchase table and the fields are -:

I want it show in crystal report like this(Here pur_date may be duplicate)

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
all the records details with duplicate pur_dates...

I'm using it in winform...
Thanks for every help......
Updated 3-Feb-13 18:51pm
RDBurmon 4-Feb-13 0:16am    
and error is..............

to be continued..

Waiting for second episode
JayantaChatterjee 4-Feb-13 0:53am    
Sir I updated the question...
please check it out..
JayantaChatterjee 4-Feb-13 1:41am    
Sir can you explain how I connect those tables with crystal report,cause I'm new in C#???

1 solution

You better change your table design for Transaction: Like this TranHead and TranLine.. In TranHead having only Purchase Date, Vendor Name,TrType, UserDateTime, User, Bill No etc. In TranLine having only SKU, Qty, Rate , Vat, etc etc . then u can get a good out put in crystal reports, grid etc. All transactions made by this tables eg: Purchase, Invoice, Estimate, Rejections etc.. Here TrType is "PUR, INV, EST, REJ"...enjoyyyyy
Share this answer
JayantaChatterjee 4-Feb-13 1:45am    
Sir can you give me the tables design structure with my table fields???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900