Home » Developer & Programmer » Reports & Discoverer » 3 Table date in one report (Developer 6I Database 10g Window XP)
3 Table date in one report [message #399457] Wed, 22 April 2009 05:43 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hellow All,

I create 3 Tables

CREATE TABLE item (
Item_date DATE,
item_no NUMBER(10),
item_name VARCHAR2(40),
rate NUMBER(10,2),
quantity NUMBER(20),
trans_item VARCHAR2(10),
catagory_no NUMBER(10),
CONSTRAINT pk_item_no PRIMARY KEY ( item_no ))


2nd table is purchase

CREATE TABLE purchase (
purchase_date DATE,
item_no_pur NUMBER(20),
item_name_pur VARCHAR2(40),
challan_no NUMBER(10),
supplier_id_pur NUMBER(10),
supplier_name_pur VARCHAR2(40),
quantity NUMBER(10,2),
rate NUMBER(10,2),
amount NUMBER(10,2),
trans_pur VARCHAR2(10),
CONSTRAINT fk_purchase_item_no FOREIGN KEY ( item_no_pur ) references item(item_no))

3rd table is Sale

CREATE TABLE sale (
sale_date DATE,
item_no_sale NUMBER(20),
item_name_sale VARCHAR2(40),
challan_no NUMBER(10),
customer_id_sale NUMBER(10),
customer_name_sale VARCHAR2(40),
quantity NUMBER(10,2),
rate NUMBER(10,2),
amount NUMBER(10,2),
trans_sale VARCHAR2(10),
CONSTRAINT fk_sale_item_no FOREIGN KEY ( item_no_sale ) references item(item_no))


Now i want a report which will show 1st date wise item record

then

date wise purchase record and then

date wise sale report

in one report its required item wise

Hope you guys understand


Thanks


shahzaib ismail
Re: 3 Table date in one report [message #399469 is a reply to message #399457] Wed, 22 April 2009 06:45 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Done it


my problem solved


Previous Topic: Help with report_object_status
Next Topic: How to bold text (return value) in function, which is displayed on report.
Goto Forum:
  


Current Time: Sat Dec 10 05:02:49 CST 2016

Total time taken to generate the page: 0.23935 seconds