Focal Point
[CLOSED] Highlighting of rows when we click on Bookmarks in PDF report output

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

September 20, 2016, 09:35 AM
Praneeth Maguluri
[CLOSED] Highlighting of rows when we click on Bookmarks in PDF report output
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
September 27, 2016, 07:46 AM
Tamra
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
September 29, 2016, 12:08 PM
Praneeth Maguluri
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
September 30, 2016, 12:31 PM
Tamra
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
October 03, 2016, 02:11 AM
Praneeth Maguluri
Tamra,

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


WebFOCUS8
Windows 7
AHTML,Excel,PDF,HTML