You want BY-EXP not BY
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 1:42 PM
To: [email protected]
Subject: [U2] Help in creating Retrieve statement for a multivalue field
My retrieve statement produced below is not formatting properly. I want
the first column to be repeated for each period.
SORT SACM.AOS.P BY FDX.Period FDX.Period FMT "30L" @ID FMT "35L"
FDX.NumOfDel LPTR SACM.AOS.P Period ##.....................
SACM.AOS.P......................... Num Of Del
06
4
01*GAN100* 01 01*GAN100*GAN100*WS09*07
1
GAN100*WS0
9*07
02
1
03
4
04
4
05
2
06
Thanks
Krish
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
