Focal Point
Formatting report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4021038331

February 08, 2005, 08:02 PM
Kamesh
Formatting 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 ,$