Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 515.5k

Fields display in first row only

Dec 13 2023 3:57 AM

Hi

     I have below Data

select t0.docentry,t0.docnum,
T0.PostDate,T0.Duedate,
T0.itemcode ,T0.prodname,T1.ItemCode 'Component Item', T0.plannedqty as [Plan Qty], from owor T0 inner join wor1 T1 on T0.DocEntry = T1.DocEntry

Id	No	Prod. Status	Item	Product	Component Item	issued
146	24400072	NULL	FG10000081	Aspirin	PM20000023	19.09
146	24400072	NULL	FG10000081	Aspirin	PM20000189	950
146	24400072	NULL	FG10000081	Aspirin	PM20000190	9501
146	24400072	NULL	FG10000081	Aspirin	PM20000191	950
146	24400072	NULL	FG10000081	Aspirin	PM20000192	14.661
146	24400072	NULL	FG10000081	Aspirin	PM20000193	190
146	24400072	NULL	FG10000081	Aspirin	PM30000038	8
146	24400072	NULL	FG10000081	Aspirin	SG10000044	5196

I want to display like it below

Id	No	Prod. Status	Item	Product	Component Item	issued
146	24400072	NULL	FG0000021	Aspirin	P2000003	19.09
					                        P2000019	950
					                        P2000010	9501
					                        P2000011	950
					                        P2000012	14.661
					                        P2000013	190
					                        P3000008	8
					                        S1000004	5196
						                                16828.751

Thanks


Answers (3)