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     [CLOSED] Highlighting of rows when we click on Bookmarks in PDF report output

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Highlighting of rows when we click on Bookmarks in PDF report output
 Login/Join
 
Member
posted
In my below code, I have bookmarks and TOC enabled for COMPOUND PDF report. But I want to highlight the corresponding row when I click on bookmark value.

COMPOUND LAYOUT PCHOLD FORMAT PDF

OBJECT=BOOKMARKS, $

OBJECT=TOC, NAME='text1',

TEXT='Table of Contents',

MARKUP=ON, TOC-NUMBERING=ON, POSITION=(0.854 0.854),

DIMENSION=(7.000 9.500), font='ARIAL', color=RGB(0 0 0),

size=10, METADATA=' TOCTITLE: Table of Contents', $

SECTION=S1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, $

PAGELAYOUT=1, $

COMPONENT=report1, TEXT='Sales By Country', TOC-LEVEL=1, BYTOC=2,

POSITION=(1 1), DIMENSION=(* *), $

COMPONENT=report2, TOC-LEVEL=1, BYTOC=2,

POSITION=(+0.00 +0.519), DIMENSION=(* *), RELATIVE-TO='report1',

RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $

END



SET PAGE-NUM = OFF

-* grab 2 rows from any data file you have and make a bogus field that

-* contains a space (SPACEKEY in this example).

TABLE FILE CAR

PRINT

-* we're not really using COUNTRY but we need to put some real field

-* in the request.

COUNTRY

COMPUTE

SPACEKEY/A1=' ';

-* we only want to 2 copies of each row later, so set this to make

-* only a 2 row FOCUS file.

IF RECORDLIMIT EQ 2

-* when making a FOCUS database, you have to name the SPACEKEY

-* as an INDEX field so you can JOIN to it.

ON TABLE HOLD AS HOLD2ROW FORMAT FOCUS INDEX SPACEKEY

END

-RUN

-TYPE Created HOLD2ROW with &LINES in it.



-* following just dumps out a list of fields in HOLD2ROW. Notice FOCLIST is

-* in the file along with SPACEKEY (and COUNTRY that we don't care about).

?FF HOLD2ROW

-RUN



-* collect your real data into a HOLD file. Typically you are

-* already making a HOLD file before the report so this shouldn't

-* be much overhead. You just need to make sure a blank field is in the

-* HOLD file. (I'm reusing SPACEKEY here)

TABLE FILE CAR

SUM

COMPUTE

SPACEKEY/A1=' ';

SALES

WHEELBASE

-*DEALER_COST

-*RETAIL_COST

BY CAR

BY COUNTRY

ON TABLE HOLD AS HOLD1

END

-RUN

-TYPE Initial data file create. Number of lines is: &LINES



-* now lets double the number of rows and get a FOCLIST counter in there.

JOIN SPACEKEY IN HOLD1 TO ALL SPACEKEY IN HOLD2ROW AS A



-* there will be a FOCLIST 1 and FOCLIST 2 now for each row that

-* was initially in the file. We'll make a single field now to hold

-* the dollar amount and for put DEALER_COST in it for FOCLIST=1

-* and we'll put RETAIL_COST in the amount field when FOCLIST=2.

DEFINE FILE HOLD1

NEW_COST /D12=IF FOCLIST EQ 1 THEN SALES ELSE

IF FOCLIST EQ 2 THEN WHEELBASE ELSE 0;

-* we need to make up some descriptive titles to use when we

-* split this up BY FOCLIST NOPRINT then BY NEW_TITLE.

NEW_TITLE /A9=IF FOCLIST EQ 1 THEN 'SALES' ELSE

IF FOCLIST EQ 2 THEN 'WHEELBASE' ELSE '?';

END



SET COMPONENT=report1

TABLE FILE HOLD1

SUM

NEW_COST AS ''

BY CAR

BY COUNTRY

BY FOCLIST NOPRINT

BY NEW_TITLE AS ''

-*SUM SALES

-*OVER WHEELBASE

-*BY CAR

-*BY COUNTRY

HEADING

"Sales by Country"

ON TABLE HOLD FORMAT PDF

ON TABLE SET STYLE *

$

TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=BLACK, $

ENDSTYLE

END



SET COMPONENT=report2

TABLE FILE CAR

SUM SALES NOPRINT

ON TABLE HOLD FORMAT PDF

END

COMPOUND END

This message has been edited. Last edited by: Praneeth Maguluri,


WebFOCUS8
Windows 7
AHTML,Excel,PDF,HTML
 
Posts: 22 | Registered: October 12, 2009Report This Post
Guru
posted Hide Post
Praneeth Maguluri,

Please review the link below. The picture shows the selection highlighted by default. Is this what you are trying to achieve?


Using Bookmarks in Document Composer

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Member
posted Hide Post
Hi Tamra,

No I am looking for highlighting the data based on bookmark selection.

Example : Consider we have bookmarks based on country ENGLAND,FRANCE etc

When I click on bookmark England, it will navigate to that record in table. Now I want to highlight that corresponding row in the table when I click on bookmark.

My issue is highlighting the table row when I click on Bookmark in PDF


WebFOCUS8
Windows 7
AHTML,Excel,PDF,HTML
 
Posts: 22 | Registered: October 12, 2009Report This Post
Guru
posted Hide Post
Praneeth,

I have not found any items in the IBI knowledgebase or within Focal Point related to styling a bookmark.

This can be a New Feature Request made through opening a case at the IBI Technical Support Center.

If you decide to open a case for this we ask that you provide a brief description on how this new feature will benefit the user community. We will submit to the programming group for review and then let you know if they decide to act on it.

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders


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

Thanks for your response and inputs.
I will open a case regarding this.


WebFOCUS8
Windows 7
AHTML,Excel,PDF,HTML
 
Posts: 22 | Registered: October 12, 2009Report 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     [CLOSED] Highlighting of rows when we click on Bookmarks in PDF report output

Copyright © 1996-2020 Information Builders