Create a Cursor with required columns in it
For example,
cInvNo1,nAmt1,cInvNo2,nAmt2,cInvNo3,nAmt3
Fill this cursor using a SCAN ENDSCAN on your main cursor.
SELECT MainCursor
SCAN
APPEND BLANK IN cSplit
REPLACE cSplit.cInvNo1 WITH ..
cSplit.nAmt1 WITH ..
SKIP IN cRepCursor
REPLACE cSplit.cInvNo2 WITH ..
cSplit.nAmt2 WITH ..
....
....
ENDSCAN
Hope that helps
Bye
Jayesh
>I want change report format from
>----------------------------------------------------------------------------
>INV No. Amount
>____________________________________________
>0001 150.00
>0002 200.00
>0003 400.00
>0004 300.00
>---------------------------------------------------------------------------
>To new format
>
>---------------------------------------------------------------------------
>INV No.. Amt. INV No.. Amt INV No. Amt
>---------------------------------------------------------------------------
>0001 150.00 0002 200.00 0003 400.00
>0004 300.00
>----------------------------------------------------------------------------
>How I can solve?
>
>Thanks
>Narong
- Jayesh