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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     When condition in webfocus 8 subhead and subfoot

Read-Only Read-Only Topic
Go
Search
Notify
Tools
When condition in webfocus 8 subhead and subfoot
 Login/Join
 
Harish
Member
posted
I am storing some data in file.There is one column(linenum) in hold file.
I want to show data in subhead when linenum>0.but it is ignoring this condition and displaying data for linenum=0 as well.

Can anyone tell me what is the best way to put when condition in subhead section in webfocus 8.Because this same query is working fine in webfocus 7.6.4


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Ram Prasad E
Master
posted Hide Post
Harish,

Below code works fine in WF 8. You may need to check the format of linenum. Is it alpha or numeric?

Total sales for France is zero. So no subhead for France.
TABLE FILE CAR
SUM
COMPUTE TOTSALES/D20=SALES; NOPRINT
BY COUNTRY
PRINT
CAR
SALES
TOTSALES NOPRINT
BY COUNTRY
ON COUNTRY SUBHEAD
"</1 SUBHEAD FOR <COUNTRY </1" 
WHEN TOTSALES GT 0 ;
ON COUNTRY SUBFOOT
"</1"
END


Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Harish
Member
posted Hide Post
Hi Ram,

Linenum field is coming from another fex file we are including this field in this fex file .we are holding this Linenum value in Hold file like --(ON TABLE HOLD AS SA_OPNBL3 FORMAT ALPHA).can you tell how this can be resolved.


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Ram Prasad E
Master
posted Hide Post
Can you share your code using CAR file.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Harish
Member
posted Hide Post
Code is:


TABLE FILE SA_OPNBL3
PRINT
OPENNING_BALANCE NOPRINT
TRANSACTION_DATE NOPRINT
RUNNING_AMT NOPRINT
COMPUTE RUN_TOTAL/D23.2 = IF EOD_ACCOUNT EQ LAST EOD_ACCOUNT
AND OPERATING_UNIT EQ LAST OPERATING_UNIT
AND GAAP EQ LAST GAAP
AND OU_COUNTERPARTY EQ LAST OU_COUNTERPARTY
AND CURRENCY EQ LAST CURRENCY
THEN RUN_TOTAL + RUNNING_AMT ELSE RUNNING_AMT; NOPRINT
COMPUTE CURRENCY_TOTAL/D23.2 = RUN_TOTAL + OPENNING_BALANCE; NOPRINT
BY PROCESSING_CNTR NOPRINT
BY CONTROL_UNIT NOPRINT
-*BY OPERATING_UNIT NOPRINT
BY OPERATING_UNIT NOPRINT &PGBRK_UNIT.EVAL
BY EOD_ACCOUNT NOPRINT
BY GAAP NOPRINT
BY OU_COUNTERPARTY NOPRINT
-*BY CURRENCY NOPRINT PAGE-BREAK
BY CURRENCY NOPRINT &PGBRK_CURR.EVAL
BY TRANSACTION_DATE NOPRINT
BY P_TRANSACTION_ID NOPRINT
ON P_TRANSACTION_ID
SUBHEAD
" WHEN LINE_NUM NE 0;

-In this LINE_NUM is coming from another file and we are including that file in this fex file.But this same code is working fine in Webfocus 7.6.4 but not working in webfocus 8.


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Harish
Member
posted Hide Post
sorry .the code is


TABLE FILE SA_OPNBL3
PRINT
OPENNING_BALANCE NOPRINT
TRANSACTION_DATE NOPRINT
RUNNING_AMT NOPRINT
COMPUTE RUN_TOTAL/D23.2 = IF EOD_ACCOUNT EQ LAST EOD_ACCOUNT
AND OPERATING_UNIT EQ LAST OPERATING_UNIT
AND GAAP EQ LAST GAAP
AND OU_COUNTERPARTY EQ LAST OU_COUNTERPARTY
AND CURRENCY EQ LAST CURRENCY
THEN RUN_TOTAL + RUNNING_AMT ELSE RUNNING_AMT; NOPRINT
COMPUTE CURRENCY_TOTAL/D23.2 = RUN_TOTAL + OPENNING_BALANCE; NOPRINT
BY PROCESSING_CNTR NOPRINT
BY CONTROL_UNIT NOPRINT
-*BY OPERATING_UNIT NOPRINT
BY OPERATING_UNIT NOPRINT &PGBRK_UNIT.EVAL
BY EOD_ACCOUNT NOPRINT
BY GAAP NOPRINT
BY OU_COUNTERPARTY NOPRINT
-*BY CURRENCY NOPRINT PAGE-BREAK
BY CURRENCY NOPRINT &PGBRK_CURR.EVAL
BY TRANSACTION_DATE NOPRINT
BY P_TRANSACTION_ID NOPRINT
ON P_TRANSACTION_ID
SUBHEAD
" WHEN LINE_NUM NE 0;


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Harish
Member
posted Hide Post
AFTER SUBHEAD AND BEFORE WHEN LINE_NUM NE 0

THIS LINE IS THEIR



WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Harish
Member
posted Hide Post
I don't know why that line is not copying here.
I that line we are printing all the values mentioned in print command +Line_Num as well.


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Ram Prasad E
Master
posted Hide Post
Place your fex code within [ code] ... [ /code]

Note: there should not be any space after "["

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Harish
Member
posted Hide Post
Can u please explain with one example using "[".


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Ram Prasad E
Master
posted Hide Post
Check if the sample code in first post is working as expected.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Harish
Member
posted Hide Post
Hi ram

Actually thing is that line_num is packed decimal datatype.So that's why it's not working.Can u tell me how i can convert this to alpha numeric datatype and where i need to do code changes for that.?


WebFOCUS 8
Windows, Excel, CSV, PDF
 
Posts: 8 | Registered: November 21, 2014Report This Post
Rifaz
Guru
posted Hide Post
Search for PTOA in help.


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     When condition in webfocus 8 subhead and subfoot

Copyright © 1996-2020 Information Builders