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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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
StuThis 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.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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