>hi cetin,
>
>the usual report i create when i want to display all employee nos is this,
>
>0001
>0002
>0003
>0004
>0005
>
>
>now i want to create a report that will display the empnos in this format,
>
>0001 0002 0003 0004 0005

select distinct empno from myTable into array arrEmps
lnEmps = _Tally
if lnEmps <= 255 && Field limit
 local array arrStruc[lnEmps,4]
 arrStruc = 0
 for ix=1 to lnEmps
   arrStruc[ix,1] = 'F'+padl(ix,3,'0')
   arrStruc[ix,2] = 'I'
   arrStruc[ix,3] = 4
 endfor
 create cursor myEmps from array arrStruc
 dimension arrEmps[1,lnEmps]
 append from array arrEmps
 brow
endif

Cetin