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



 



Edited by aisofts - 23 Mar 2009 at 5:12am