Howto: Show Additional linked Data from Database into Crystal Report Detail Section
-
I have a database including tables Item_Master(Item_Code, Item_Model) Invoice(Invoice_Code, Invoice_Amount, etc) Invoice_Item(Invoice_Code, Item_Code, Item_Model, Item_Make, Unit_Price, Quantity) Invoice_Item_Serial_Number(Invoice_Code, Item_Code, Serial_Number_1, Serial_Number_2) Invoice_Item_Serial_Number.Invoice_Code refers Invoice.Invoice_Code Invoice_Item_Serial_Number.Item_Code refers Item_Master.Item_Code Invoice_Item.Invoice_Code refers Invoice.Invoice_Code Invoice_Item.Item_Code refers Item_Master.Item_Code Each Item has atleast One serial Number I wish to get the following output in crystal report.
Item_Code Item_Model Item_Make Unit_Price Quantity Total
22 AC12 Bluestar 18000 1 18000
Serial Number_1 Serial Number_2
DXDEC11 DXSDSC2224 AC1 Bluestar 15000 3 45000
Serial Number_1 Serial Number_2
REDDED3 EWSSD34
DEF443D DEWS332
REFSD23 EWWDW3422 AC08 Bluestar 12000 1 12000
Serial Number_1 Serial Number_2
FSDXDEC11 XSDDC22Can you please let me know how should I setup my Crystal Report's Detail section to get the above output Thanks Sukhjinder
Looking for help on my OpenSource Media Player LetsYo