I have these table CustomerMaster, Sales, Product_details
I made a crystal report from these tables …like
CustomerCode CustomerName TotalSales ProductName
11111001 rahul 230 Product1
122220 sam 452 product2
.
But I want my report look like that…..
CustomerCode CustomerName TotalSales product1 product2 product3………
11111001 rahul 230
122220 sam 452
Please help me….