how to merge two crystal report

i want to merge two crystal report on basis of its field...

i have two views and create two crystal report 1 and report 2

report1 is create to use table itemMaster and CustomerInvDetails which have field Itemcode,itemdetails join with itemcode

report 2 is create to use table CustomerMaster and CustomerInvoice join with CustomerCode.....

how to merge these two reports....

i want my final report look like below

CustomerCode CustomerName TotalSale Productname1. productName2.......productname 25 Date

1001 sam 5455 y n y 01/02/2005

...

these fields come from dbo.CustomerMaster.CustomerCode , dbo.CustomerMaster.CustomerName,

dbo.CustomerInvoice.TotalSales ,dbo.ItemMaster.ProductDescription(ProductName) ,dbo.customerInvoice.Date

how can i make above report...

please help me

its urgent.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.