I have these table CustomerMaster, Sales, Product_details
I made a crystal report from these tables …like
CustomerCode CustomerName TotalSales ProductName
11111001 rahul 230 ProductName1
122220 sam 452 productnName2
.
.
.
i have this ProductName field in my table ProductTable but i want to use this field value like a field in my Crystal report
I want my report look like this given below..
CustomerCode CustomerName TotalSales productName1 productName2 productName3………
11111001 rahul 230 y y y
122220 sam 452 y y y
.
.
Please help me….
Kirtan PatelPosted Jan 3, 2010, 6:23 PM
see below screen Shot From My Laptop
Just Insert Cross Tab on report then Hide the Filed that you dont want to Show by Right Click >> Format >> Tick Suppress