pls. if anyone have solution for this........
I made a databse table shown in below.......

item	Description	Qty	Supplier	Rate	Amount
1	aaaa	10	Supplier1	100	1000
2	bbb	20	Supplier1	200	4000
3	cccc	30	Supplier1	300	9000
1	aaaa	10	Supplier2	50	500
2	bbb	20	Supplier2	60	1200
3	cccc	30	Supplier2	70	2100
1	aaaa	10	Supplier3	100	1000
2	bbb	20	Supplier3	300	6000
3	cccc	30	Supplier3	400	12000

i want to view report as follows in crystal report..... pls help me to do this..........

Item	Description	Qty	Supplier 1		Suppler 2		Supplier3		…….
			Rate	Amount	Rate	Amount	Rate	Amount	Rate	Amount
1	aaaa	10	100	1000	50	500	100	1000
2	bbb	20	200	4000	60	1200	300	6000
3	cccc	30	300	9000	70	2100	400	12000

Edited by ipgodahenage - 12 Jul 2011 at 10:25pm