Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSE] Variable Headers
Go
New
Search
Notify
Tools
Reply
  
[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: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport 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: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
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.0.09
 
Posts: 237 | Location: Melbourne, Australia | Registered: February 07, 2007Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport 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: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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, 2009Reply With QuoteReport 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: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport 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: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Should be under here, correct?



WebFocus 8.2, IA+, Windows 10, HTML
 
Posts: 54 | Location: UT | Registered: December 01, 2015Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSE] Variable Headers

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