February 08, 2005, 08:02 PM
KameshFormatting report
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.
February 08, 2005, 11:39 PM
<Zushi Hitoshi>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 ,$