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     [SOLVED] SUB HEADER ISSUE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] SUB HEADER ISSUE
 Login/Join
 
Master
posted
Supression works fine at the subtotal level but fails to work on my subheader...is there a known issue with using this structure on a header?

.
.
.
ON HOLDDETAIL.CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT HOLDDETAIL.CUSTGRP3 IN ('Other Stats', 'Other Rev');

ON HOLDDETAIL.CUSTGRP3 SUBFOOT
" "

ON HOLDDETAIL.CUSTGRP2 SUBHEAD "WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'

ON HOLDDETAIL.CUSTGRP2 SUBTOTAL AS ''
WHEN NOT HOLDDETAIL.CUSTGRP2 IN ('wRVUs', 'Units','Salaries','Charges','Panel Size','Other Stats','Addendum');

ON HOLDDETAIL.CUSTGRP2 SUBFOOT
" ".
.
.

It fails to suprress the Sub header when the value = 'Addendum'.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
quote:
ON HOLDDETAIL.CUSTGRP2 SUBHEAD "WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'



..there was a typo in my post..should have read:
ON HOLDDETAIL.CUSTGRP2 SUBHEAD WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
this does not work either:

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"

WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
not sure why my cut/paste not working...should have read...'this is not working either...'

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"

WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
one more time...

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD

..note I have quotes around

WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
must be an html thing....

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"CUSTGRP2"

(have a less than sign before CUSTGRP2 in actual code)


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
CLOSED*****


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Virtuoso
posted Hide Post
Robert, please use [ CODE ] tags (without the spaces) around your code snippets so they get properly rendered.

A conditional subhead would look like this:
ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"My subhead here"
WHEN HOLDDETAIL.CUSTGRP2 NE 'Addendum'



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Master
posted Hide Post
Thanks I will try that.


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
for some reason that does not work...it still shows the header even when it equals 'Addendum'

Similar code works at the subtotal level just not at the subheader.


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Virtuoso
posted Hide Post
Please test this code:
TABLE FILE CAR
PRINT COUNTRY AND CAR AND MODEL
BY COUNTRY
ON COUNTRY SUBHEAD
"Country: <COUNTRY"
WHEN COUNTRY NE 'JAPAN'
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
END


You should get a SUBHEAD for each COUNTRY except for JAPAN.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Master
posted Hide Post
quote:
TABLE FILE CAR
PRINT COUNTRY AND CAR AND MODEL
BY COUNTRY
ON COUNTRY SUBHEAD
"Country: WHEN COUNTRY NE 'JAPAN'
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
END

That works in the CAR file. Itried and see it. It does not work in my file. I'll try pasting my code in again...

[TABLE FILE HOLDDETAIL
SUM
HOLDDETAIL.HOLDDETA.TTLAMT/P20.2CB AS 'Ttl'
BY LOWEST CUSTGRP3SORT NOPRINT
BY LOWEST CUSTGRP3 NOPRINT
BY LOWEST CUSTGRP2SORT NOPRINT
BY LOWEST CUSTGRP2 NOPRINT
BY LOWEST CUSTGRP1SORT NOPRINT
BY LOWEST CUSTGRP1 NOPRINT
BY LOWEST SORTNBR NOPRINT AS 'Sort'
BY LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'

ON CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT CUSTGRP3 IN ('Other Stats');
ON CUSTGRP3 SUBFOOT
" "
ON CUSTGRP2 SUBHEAD
"

WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
I am note sure what code tags are...I can not get my actual code posted, perhaps if someone tells me how I will post it. I though it was simple as putting '[' and ']' around the code.


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
one last try...wish they had a preview on this forum!

[TABLE FILE HOLDDETAIL
SUM
HOLDDETAIL.HOLDDETA.TTLAMT/P20.2CB AS 'Ttl'
BY LOWEST CUSTGRP3SORT NOPRINT
BY LOWEST CUSTGRP3 NOPRINT
BY LOWEST CUSTGRP2SORT NOPRINT
BY LOWEST CUSTGRP2 NOPRINT
BY LOWEST CUSTGRP1SORT NOPRINT
BY LOWEST CUSTGRP1 NOPRINT
BY LOWEST SORTNBR NOPRINT AS 'Sort'
BY LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'

ON CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT CUSTGRP3 IN ('Other Stats');
ON CUSTGRP3 SUBFOOT
" "
ON CUSTGRP2 SUBHEAD
"

WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
no dice!


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Virtuoso
posted Hide Post
Robert,

quote:
no dice!


You will get the tags for code by clicking on the right-most button in the reply post. It is easy to find as it is the only one in red.
Post your code with it and then we can try and help.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Master
posted Hide Post
Robert: If you look at the little icon bar above where you enter your message you'll see a button at the extreme right.

Click that and you will see the code tags. Just insert your code between those two tags. (You don't have to use the button - you can just type the respective tags at the top and bottom of your code).


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Report This Post
Master
posted Hide Post
code:

TABLE FILE HOLDDETAIL
SUM 
     TTLAMT/P20.2CB AS 'Ttl'
BY  LOWEST CUSTGRP3SORT NOPRINT 
BY  LOWEST CUSTGRP3 NOPRINT 
BY  LOWEST CUSTGRP2SORT NOPRINT 
BY  LOWEST CUSTGRP2 NOPRINT 
BY  LOWEST CUSTGRP1SORT NOPRINT 
BY  LOWEST CUSTGRP1 NOPRINT 
BY  LOWEST SORTNBR NOPRINT  AS 'Sort'
BY  LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'
     
ON CUSTGRP3 SUBTOTAL AS '*'  
WHEN NOT HOLDDETAIL.HOLDDETA.CUSTGRP3 IN ('Other Stats');

ON CUSTGRP3 SUBFOOT
" "

ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 " WHEN CUSTGRP2 NE 'Addendum'

ON CUSTGRP2 SUBTOTAL AS ''  
WHEN NOT CUSTGRP2 IN ('wRVUs', 'Units','Salaries','Charges','Panel Size','Other Stats','Addendum','FTEs');
.
.
. 



All Subtotal supression works fine. Subhead...not so good....does not supress on: 'Addendum'


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Virtuoso
posted Hide Post
Robert,

This worked for me:
  
-* File Robert2.fex
TABLE FILE CAR
SUM SALES
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY BODYTYPE
ACROSS SEATS
ON COUNTRY SUBTOTAL AS '*'
WHEN NOT COUNTRY IN ('FRANCE')
ON COUNTRY SUBFOOT
" "
ON CAR SUBHEAD
"<CAR "
WHEN CAR NE 'JAGUAR'
ON CAR SUBTOTAL
WHEN NOT CAR IN ('JAGUAR', 'MASERATI')
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT, $
ENDSTYLE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Master
posted Hide Post
I believe you...just not sure why my code does not!


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Virtuoso
posted Hide Post
If I may suggest, try some good old fashioned salami debugging: cut out all the superfluous, see that you get what you want and then add slice by slice...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Virtuoso
posted Hide Post
[quote]
ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 " WHEN CUSTGRP2 NE 'Addendum'
[quote]

RobertF, your code doesn't follow the syntax we suggested. The WHEN clause should be on a line of its own!

Try this:

...
ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 "
WHEN CUSTGRP2 NE 'Addendum'
...



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Master
posted Hide Post
I think that was it...the WHEN on its own line...but I dicovered the solution thru another means that made no sense to me...so thanks for the post!

I whittled my code down to this:

 TABLE FILE HOLDDETAIL
BY  HOLDDETAIL.HOLDDETA.CUSTGRP2
     
ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"<CUSTGRP2"  WHEN CUSTGRP2 NE 'Addendum';
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END 



It was still acting up. So changed the report type to HTML. It worked. I then changed it back to Excel...to my surprise..it worked. It appears the GUI somehow dropped the WHEN to its own line. At least I understand it now..I was thinking it was some sort of bug.

THANKS ALL!!!


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 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     [SOLVED] SUB HEADER ISSUE

Copyright © 1996-2020 Information Builders