Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Item Stock detail using sale and purchase table Post Reply Post New Topic
Author Message
aisofts
Newbie
Newbie
Avatar

Joined: 23 Mar 2009
Location: Pakistan
Online Status: Offline
Posts: 1
Quote aisofts Replybullet Topic: Item Stock detail using sale and purchase table
    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



 



Edited by aisofts - 23 Mar 2009 at 5:12am
Thanks for your assistance
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.