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     [CLOSE] Variable Headers

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSE] Variable Headers
 Login/Join
 
Gold member
posted
I'd like to change the header of a report based on the page number. I've seen some conditional header threads on the forum but putting that code into the header doesn't work.

so IF PAGENO EQ 1 THEN Something ELSE IF PAGENO EQ 2 THEN Something ELSE something

Or any other work around using defines or something, really I just want the header to change per page depending on the page number.

This message has been edited. Last edited by: Tamra,


WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Expert
posted Hide Post
I don't believe that you can base it on page number. but that experience was from 7.6, perhaps there is a way now ??


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Thanks for the reply.

I have a field that only changes when the page changes so if there is a way to base it off of that field that would work too. I have it set so there's only 100 records per page by a field that is limited to 100 records so every 100 records that field changes and so does the page. I would like that field in the header if possible (changing per page), if not I'll just have to live without it, seems like there would be a way to do that though.


WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Expert
posted Hide Post
The heading layout can't change as far as I know,but SUBHEAD's can with the WHEN clause, this can be based on a field value.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
You will need to use WHEN with your HEADING syntax

With the CAR file:

TABLE FILE CAR
SUM CAR.BODY.SEATS
BY CAR.ORIGIN.COUNTRY PAGE-BREAK
HEADING
"This is the first page"
"My Report <TABPAGENO<+0> OF <TABLASTPAGE"
WHEN TABPAGENO EQ 1
HEADING
"My Report <TABPAGENO<+0> OF <TABLASTPAGE"
WHEN TABPAGENO GT 1
HEADING
"This is Page four"
WHEN TABPAGENO EQ 4
HEADING
"The Last Page"
WHEN TABPAGENO EQ TABLASTPAGE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
ENDSTYLE
END  


Gives the following output

This is the first page
My Report 1 OF 5

COUNTRY SEATS
ENGLAND 13


My Report 2 OF 5
COUNTRY SEATS
FRANCE 5


My Report 3 OF 5
COUNTRY SEATS
ITALY 10


My Report 4 OF 5
This is Page four

COUNTRY SEATS
JAPAN 8


My Report 5 OF 5
The Last Page

COUNTRY SEATS
W GERMANY 34

Cheers

Stu

This message has been edited. Last edited by: StuBouyer,


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
Expert
posted Hide Post
Wow, didn't know that Stu.

Learn something every day.

Good One


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Thank you StuBouyer!

Would there be anyway to implement this in InfoAssist without directly accessing the code?

I could most likely get someone to insert this for me after the fact but the goal
at where I'm currently working is to get everything to work by just using InfoAssist
without bugging the developers (Who are the only ones with code access)
to make modifications to your FEX files.


WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Guru
posted Hide Post
Cimmerian,

At this time the WHEN clause is not available within InfoAssist.

You have the option to open a case at IBI Technical Support and request a New Feature Request for this option to be added to the product.

Add in a brief business justification why this option would be beneficial to the User community.

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Gold member
posted Hide Post
Thank you Tamara,

When I visit the link it brings me to the "Technical Support Center" but I don't see a link anywhere to open a case. Do I have to call the number to open a case?

There is a message saying "Please add a site code to your profile to see the requested content." immediately after clicking the link provided also.

Thanks.


WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Expert
posted Hide Post
Hi Cimmerian,

You have to log in.

There is a login link under My Account.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Thanks Waz,

first thing I did was create an account and log in, I am not seeing any options to submit a case after doing that.


WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Expert
posted Hide Post
When you are logged in, there should be a "Case Management" link under "My Account"


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Should be under here, correct?



WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 56 | Location: UT | Registered: December 01, 2015Report This Post
Expert
posted Hide Post
Yes, you will need to add a site code to be able to submit a case


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     [CLOSE] Variable Headers

Copyright © 1996-2020 Information Builders