Print Page | Close Window

Item Stock detail using sale and purchase table Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5854 Printed Date: 21 May 2024 at 12:55pm Topic: Item Stock detail using sale and purchase table Posted By: aisofts Subject: Item Stock detail using sale and purchase table Date Posted: 23 Mar 2009 at 2:56am Hi dear, This is my first post and want help from some one. My question is below: I have five tables with fields named below:       -  purchase            (*purchase_id, purchase_date, company_id)       -  purchase-detail  (purchase_id, qty, product_id, unit_id)       -  sale                    (*sale_id, sale_date)       -  sale-detail          (sale_id, qty, company_id, product_id, unit_id))    Note - * represents primary key (company_id, product_id, unit_id) makes one item. I am creating a crystal report using vb.net 2008 and I have to create specific Item detail, in which date it is sold out , in which date it is purchased. I have created crystal report 4 columns below in which data will be placed Date(sale/purchase)  |  Purchase Quantity | Sale Quantity | Rem. Quantity 23/03/09                       |  300                          |                       | 300 24/03/09                       |                                 | 100                 | 200      25/03/09                       |  100                          | 200                 | 100    The above format will be used with different possibilities of sale purchase I have different and same dates in sale and purchase tables with multiple quantity values for same date . Please help me to solve this question . I am unable to create the queries. Many thanks in Advance   ------------- Thanks for your assistance

Print Page | Close Window