 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSE] Variable Headers | Login/Join |
| Gold member |
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 | ||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
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 | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Guru |
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) | |||
|
| Expert |
Wow, didn't know that Stu. Learn something every day.  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
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 | |||
|
| Guru |
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 | |||
|
| Gold member |
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 | |||
|
| Expert |
Hi Cimmerian, You have to log in. There is a login link under My Account. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
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 | |||
|
| Expert |
When you are logged in, there should be a "Case Management" link under "My Account" Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Should be under here, correct?  WebFocus 8.2, IA+, Windows 10, HTML | |||
|
| Expert |
Yes, you will need to add a site code to be able to submit a case Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |