Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Formatting report
 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: 780 | Location: Florida | Registered: January 09, 2005Report This Post
<Zushi Hitoshi>
posted
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 ,$
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders