IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Formatting report
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Master
Posted
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.
 
Posts: 552 | Location: cincinnati | Registered: January 09, 2005Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
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 ,$
 
Posts: 6 | Location: osaka,japan | Registered: January 31, 2005Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Formatting report

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.