|
Go
![]() |
New
![]() |
Search
![]() |
Notify
![]() |
Tools
![]() |
Reply
![]() |
|
|
Master |
In table have one field called description and that will have the values like
T R A N S A C T I O N S REMITTER NAME CHECK AM INV JABIL CIRCUIT INC 230.28 8197 1,892.20 400797 MATTRACKS IN while I'm displaying these values in report, I need to show as T R A N S A C T I O N S REMITTER NAME CHECK AM INV JABIL CIRCUIT INC 230.28 8197 MATTRACKS IN 1,892.20 400797 these records will be dynamic based on the user. Like we may get the data's like REMITTER NAME CHECK AM CHECK DATE INV AMT PAID YMCA OF STPAUL 250.34 9/24/05 4567 456 let me know if you have any idea about this issue. |
||
|
|
Member |
It is difficult.IF you hope only Html Report,
Then following cording DEFINE FILE TRUNSACTION WDATA/A80=LJUST(80,DATA,WDATA); W1GETTOK/A50=GETTOK(WDATA,80,1,' ',50,W1GETTOK); W2GETTOK/A50=GETTOK(WDATA,80,2,' ',50,W2GETTOK); W3GETTOK/A50=GETTOK(WDATA,80,3,' ',50,W3GETTOK); W4GETTOK/A50=GETTOK(WDATA,80,4,' ',50,W4GETTOK); W5GETTOK/A50=GETTOK(WDATA,80,5,' ',50,W5GETTOK); W1CHKFMT/I4=CHKFMT(1,EDIT(W1GETTOK,'9'),'9',W1CHKFMT); W2CHKFMT/I4=CHKFMT(1,EDIT(W2GETTOK,'9'),'9',W2CHKFMT); W3CHKFMT/I4=CHKFMT(1,EDIT(W3GETTOK,'9'),'9',W3CHKFMT); W4CHKFMT/I4=CHKFMT(1,EDIT(W4GETTOK,'9'),'9',W4CHKFMT); W5CHKFMT/I4=CHKFMT(1,EDIT(W5GETTOK,'9'),'9',W5CHKFMT); W1DATA/A300=IF W1CHKFMT NE 0 THEN DATA ELSE IF W2CHKFMT NE 0 THEN W2GETTOK|W3GETTOK|W4GETTOK|W5GETTOK|W1GETTOK ELSE IF W3CHKFMT NE 0 THEN W3GETTOK|W4GETTOK|W5GETTOK|W1GETTOK|W2GETTOK ELSE IF W4CHKFMT NE 0 THEN W4GETTOK|W5GETTOK|W1GETTOK|W2GETTOK|W3GETTOK ELSE W5GETTOK|W1GETTOK|W2GETTOK|W3GETTOK|W4GETTOK; END TABLE FILE TRUNSACTION PRINT DATA W1DATA END TRUNSACTION.mas is FILE=TRUNSACTION,SUFFIX=FIX SEGMENT=TRUNSACTION FIELD=DATA ,DATA ,A80 ,A80 ,$ |
|||
|
| Previous Topic | Next Topic | powered by eve community |
| Please Wait. Your request is being processed... |
|

