Focal Point
[CLOSE] Variable Headers

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9947091286

May 05, 2016, 01:00 PM
Cimmerian
[CLOSE] Variable Headers
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
May 05, 2016, 04:28 PM
Waz
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!

May 06, 2016, 12:36 PM
Cimmerian
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
May 08, 2016, 06:22 PM
Waz
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!

May 09, 2016, 02:05 AM
StuBouyer
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)
May 09, 2016, 02:11 AM
Waz
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!

May 09, 2016, 01:06 PM
Cimmerian
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
May 11, 2016, 07:53 AM
Tamra
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
May 11, 2016, 03:28 PM
Cimmerian
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
May 11, 2016, 04:51 PM
Waz
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!

May 11, 2016, 05:59 PM
Cimmerian
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
May 11, 2016, 06:07 PM
Waz
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!

May 11, 2016, 06:49 PM
Cimmerian
Should be under here, correct?




WebFocus 8.2, IA+, Windows 10, HTML
May 11, 2016, 06:56 PM
Waz
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!