Multiple Records Printing From Multiple Tables (DB)

[shah0101]

Dear Sir(s) / Madam(s),

I have a problem in creating a crystal report, I have contacted several programmers but no bodody has any proper clue for that, then some told me about that site and said that this could solve this problem for sure.


my task is :-
================
I have four tables in a database as follows :-

table "A" table "B" table "C" table "D"
Master Transation Transation Transation
----------- ----------- --------------- ----------
1. A.Costcode B.CostCode C.CostCode D.CostCode
2. A.Buyer B.mtrs C.Desc D.Desc
3. A.SopNo B.width C.Grams D.KGS
4. A.rebate B.price C.Price D.Price
5. B.Value C.Value D.Value


Now in crystal report writer I selected custom report,
how may I print the records in following format :-

QUOTE

A.CostCode ___________ A.Buyer ____________
A.Sop No. ___________ A.Rebate____________

---
FABRIC DETAIL : I HAVE FETCHED
============= : THESE ITEMS IN
MTRS WIDTH PRICE VALUE : SECTION OF
---- ----- ----- ------ \ CRYSTAL REPORT
B.MTRS B.WIDTH B.PRICE B.VALUE / SUCCESSFULLY
B.MTRS B.WIDTH B.PRICE B.VALUE : DETAILS
B.MTRS B.WIDTH B.PRICE B.VALUE :
B.MTRS B.WIDTH B.PRICE B.VALUE :
---





---
WADDING DETAIL : ** WHERE AND
============== : HOW SHOULD I
DESC GRAMS PRICE VALUE : PUT THESE
---- ----- ----- ------ \ ITEMS SO I
C.DESC C.GRAMS C.PRICE C.VALUE / COULD FETCH
C.DESC C.GRAMS C.PRICE C.VALUE : ALL LINKED
C.DESC C.GRAMS C.PRICE C.VALUE : (RELATED)
C.DESC C.GRAMS C.PRICE C.VALUE : RECORDS FROM
--- FILE "C" IN
THE SAME
PATTERN AS
DISPLAYED


---
THREAD DETAIL : ** WHERE AND
============== : HOW SHOULD I
DESC KGS PRICE VALUE : PUT THESE
---- ----- ----- ------ \ ITEMS SO I
D.DESC D.KGS D.PRICE D.VALUE / COULD FETCH
D.DESC D.KGS D.PRICE D.VALUE : ALL LINKED
D.DESC D.KGS D.PRICE D.VALUE : (RELATED)
D.DESC D.KGS D.PRICE D.VALUE : RECORDS FROM
--- FILE "C" IN
THE SAME
PATTERN AS
DISPLAYED




UNQUOTE

** THIS IS THE PROBLEM


Please help me out.

Thanks

Shakir