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     [CASE-OPENED] How to make the text as hyperlink in document composer
Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] How to make the text as hyperlink in document composer
 Login/Join
 
Gold member
posted
Hi All,

I am working in Document Composer. How to make the Below String as hyperlink.

OBJECT=STRING, NAME='text8', TEXT='
Impotant Legal Information
', POSITION=(17.542 15.042), MARKUP=ON, WRAP=ON, DIMENSION=(4.167 0.292), style=bold, METADATA='', $

This message has been edited. Last edited by: <Kathryn Henning>,


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Gold member
posted Hide Post
I tried to gave like below.

OBJECT=STRING, URL='https://www.google.co.in/', NAME='text10', TEXT='Target List', POSITION=(18.127 15.333), MARKUP=OFF, WRAP=ON, DIMENSION=(3.038 0.681), font='ARIAL', color=RGB(0 0 0), size=10, $

but i got error like this "Unknown error occurred. Agent on reporting server EDASERVE may have crashed or request was halted by the operator. Please investigate reporting server log."

What will be the error?


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Gold member
posted Hide Post
no one?


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Master
posted Hide Post
Judging by the code...

- You are in de "Composer (layout)"?
- Output? html / pdf?
- Do you get the same error without the code you posted?
- Did you try to make the link in the GUI?

a lot of 'unknowns' for us...


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Gold member
posted Hide Post
I tried to give the hyperlink in Document Composer.
I am generating PDF report.

Why i used this Document Composer for my report because in my report, two tables are there(these tables having different number of columns). one after the other(in same page). For each and every page header and footer should be there.

So i used document composer. Now i want to give hyper link in footer section. So i gave the text as below

OBJECT=STRING, NAME='text10', TEXT='Target List', POSITION=(18.127 15.333), MARKUP=OFF, WRAP=ON, DIMENSION=(3.038 0.681), font='ARIAL', color=RGB(0 0 0), size=10, $

it worked.... Now i want to make this text as hyperlink. I gave like below.

OBJECT=STRING, URL='https://www.google.co.in/', NAME='text10', TEXT='Target List', POSITION=(18.127 15.333), MARKUP=OFF, WRAP=ON, DIMENSION=(3.038 0.681), font='ARIAL', color=RGB(0 0 0), size=10, $

then error came "Unknown error occurred. Agent on reporting server EDASERVE may have crashed or request was halted by the operator. Please investigate reporting server log."

Can we solve this by using DRILLTHROUGH or DRILLDOWN function?

For me there is no restriction to use Document Composer only need is to create PDF report.Is there any other way of creating PDF report as per my requirement?


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Member
posted Hide Post
If all else fails, you could just create or embed a new fex into your document, with the hyperlink already inserted in the procedure.

 
TABLE FILE CAR
BY CAR NOPRINT
HEADING
"informationbuilders.com"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=HEADING,
     URL=www.informationbuilders.com,
$
ENDSTYLE
END
 


Erfan


WebFOCUS 77, Windows, HTML PDF EXCEL
 
Posts: 11 | Registered: November 28, 2011Report This Post
Master
posted Hide Post
Hello,
You need to change MARKUP to ON and include HTML keywords to get the hyperlink.
OBJECT=STRING, TEXT='<a href="http://www.google.com">Target</a> List', POSITION=(5.127 5.333), MARKUP=ON, WRAP=ON, 
DIMENSION=(3.038 1.681), font='ARIAL', color=RGB(0 0 0), size=10, $


Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Gold member
posted Hide Post
ebaig:
I tried to give like this as you said. It is printing in the place basing upon the value Dimension attribute but i wan to display hyperlink as a footer for every page.

I don't think this will come for every page. After embed this procedure in my document, i need to change any properties to get this hyperlink in every page?


Ram Prasad E:

I gave like below

OBJECT=STRING, NAME='text10', TEXT='
Target
', POSITION=(17.917 15.592), MARKUP=ON, WRAP=ON, DIMENSION=(3.038 1.681), font='ARIAL', color=RGB(0 0 0), size=10, $

then its displaying "Target" tag. but not "Target" as hyperlink.


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Gold member
posted Hide Post
Sorry Ram Prasad E

I tried as you said. Its printing the html code with anchor tag but not the value in between the anchor tag as a hyper link

'
<a href="http://www.google.com">Target</a> 
'


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Master
posted Hide Post
Can you share complete code that you are trying out.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Guru
posted Hide Post
Santu, you should try a suggestion out before you assume. Ebaig's solution works.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Gold member
posted Hide Post
J: I tried the solutions which are all given. If i go failures then only i am posting.

Here is my code:


 -SET &HOUR    = EDIT(&TOD,'99');
-SET &M       = IF &TOD GT '12.00.00' THEN 'PM' ELSE 'AM';
-SET &FLAG    = IF &TOD GT '13.00.00' THEN 1 ELSE 0 ;
-SET &HOUR    = IF &FLAG IS 1 THEN &HOUR - 12 ELSE &HOUR ;
-SET &MINUTES = EDIT(&TOD,'$$$99');
-SET &SECONDS = EDIT(&TOD,'$$$$$$99');
-SET &TIME    = &HOUR | ':' | &MINUTES |':'|&SECONDS;

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.0^1.0^0.0^0.8^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=C size sheet, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.624 2.292), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.879in; HEIGHT: 1.978in; TOP: 2.292in; LEFT: 0.624in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(+0.001 +0.209), DIMENSION=(* *), RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.917in; HEIGHT: 2.708in; TOP: 4.479in; LEFT: 0.625in', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(+0.000 +0.209), DIMENSION=(* *), RELATIVE-TO='report2', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.917in; HEIGHT: 1.042in; TOP: 7.396in; LEFT: 0.625in', $
OBJECT=STRING, NAME='text1', TEXT='<font face="TAHOMA" size=14><center>Fund Company : 00025 Growth Company</center></font>', POSITION=(8.250 0.917), MARKUP=ON, WRAP=ON, DIMENSION=(6.167 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME='text2', TEXT='<font face="TAHOMA" size=14>&DATEMDYY &TIME</font>', POSITION=(18.417 0.917), MARKUP=ON, WRAP=ON, DIMENSION=(3.167 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME='text4', TEXT='<font face="TAHOMA" size=14>FPCMS Control and Reconciliation Services</font>', POSITION=(0.667 0.917), MARKUP=ON, WRAP=ON, DIMENSION=(6.167 0.292), style=bold, METADATA='', $
OBJECT=IMAGE, NAME='image1', IMAGE=logo.gif, POSITION=(0.729 0.208), DIMENSION=(2.393 0.556), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 2.393in; HEIGHT: 0.556in; TOP: 0.208in; LEFT: 0.729in', $
OBJECT=STRING, NAME='text5', TEXT='<font face="TAHOMA" size=14><center>iTAAC Fiscal Year End Activity</center></font>', POSITION=(9.042 1.250), MARKUP=ON, WRAP=ON, DIMENSION=(4.167 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME='text6', TEXT='<font face="TAHOMA" size=14><center>As Of : 05/21/2013</center></font>', POSITION=(9.042 1.542), MARKUP=ON, WRAP=ON, DIMENSION=(4.167 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME='text7', TEXT='<font face="TAHOMA" size=12 color=#0000ff><center>Fidelity Confidential Information</center></font>', POSITION=(8.042 15.042), MARKUP=ON, WRAP=ON, DIMENSION=(6.167 0.292), style=bold+UNDERLINE, METADATA='', $
OBJECT=STRING, NAME='text8', TEXT='<font face="TAHOMA" size=12 color=#0000ff><center>Impotant Legal Information</center></font>', POSITION=(17.542 15.042), MARKUP=ON, WRAP=ON, DIMENSION=(4.167 0.292), style=bold+UNDERLINE, METADATA='', $
OBJECT=STRING, NAME='text9', TEXT='<font face="TAHOMA" size=12><center>Page : <ibi-page-number/></center></font>', POSITION=(17.917 15.292), MARKUP=ON, WRAP=ON, DIMENSION=(4.167 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME='text10', TEXT='<font face="TAHOMA" size=12><center><a href="http://www.google.com">Target</a></center></font>', POSITION=(17.917 15.592), MARKUP=ON, WRAP=ON, DIMENSION=(3.038 1.681), font='ARIAL', color=RGB(0 0 0), size=10, $
END
SET COMPONENT='report1'
-*component_type report
-SET &HOUR    = EDIT(&TOD,'99');
-SET &M       = IF &TOD GT '12.00.00' THEN 'PM' ELSE 'AM';
-SET &FLAG    = IF &TOD GT '13.00.00' THEN 1 ELSE 0 ;
-SET &HOUR    = IF &FLAG IS 1 THEN &HOUR - 12 ELSE &HOUR ;
-SET &MINUTES = EDIT(&TOD,'$$$99');
-SET &SECONDS = EDIT(&TOD,'$$$$$$99');
-SET &TIME    = &HOUR | ':' | &MINUTES |':'|&SECONDS;
ENGINE SQLORA SET DEFAULT_CONNECTION AUDIT_APP
SQL SQLORA PREPARE SQLOUT FOR
-INCLUDE app/MaintainTAAC_Shares_Bal.sql
END
DEFINE FILE SQLOUT
DAYSKEPT/A2 = '';
END
TABLE FILE SQLOUT
-*	 BACKCOLOR=RGB(210 210 210),
PRINT
PROCESSDATE AS 'Process, Date'
DESCRIPTION AS 'Description,'
SHAREAMOUNT/D30.3B AS 'Outstanding, Shares'
PURCHASESSHARES/D30.3B AS 'Purchases, Shares'
PURCHASESDOLLARS/D30.2MB AS 'Purchases, Dollars'
REDEMPTIONSHARES/D30.3B AS 'Redemtions, Shares'
REDEMTIONDOLLARS/D30.2MB AS 'Redemtions, Dollars'
REDEMTIONFEESDOLLARS/D30.2MB AS 'Redemtion Fees, Dollars'
DIVIDENDREINVESTMENTSHARES/D30.3B AS 'Dividend, Reinvestments, Shares'
DIVIDENDREINVESTMENTDOLLARS/D30.2MB AS 'Dividend, Reinvestments, Dollars'
BY DAYSKEPT AS ''
HEADING
"Ending Balances"
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL' PURCHASESSHARES PURCHASESDOLLARS REDEMPTIONSHARES REDEMTIONDOLLARS REDEMTIONFEESDOLLARS DIVIDENDREINVESTMENTSHARES DIVIDENDREINVESTMENTDOLLARS
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='C size sheet',
LEFTMARGIN=0.750000,
RIGHTMARGIN=0.750000,
ORIENTATION=LANDSCAPE,
$
TYPE=TITLE,
FONT='TAHOMA',
STYLE=BOLD,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N1,
FONT='TAHOMA',
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N2,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N3,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N5,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N6,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N9,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N11,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N12,
BORDER-BOTTOM=LIGHT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(*),
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=HEADING,
OBJECT=TEXT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.750,
$
TYPE=GRANDTOTAL,
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.402778,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.027778,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=2.305556,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=2.000000,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=1.763889,
JUSTIFY=RIGHT,
$
ENDSTYLE
END
SET COMPONENT='report2'
-*component_type report
ENGINE SQLORA SET DEFAULT_CONNECTION AUDIT_APP
SQL SQLORA PREPARE SQLOUT FOR
-INCLUDE app/MaintainTAAC_Shares_Prf.sql
END
DEFINE FILE SQLOUT
DAYSKEPT/A2 = '';
END
TABLE FILE SQLOUT
-*	 BACKCOLOR=RGB(210 210 210),
-*     BACKCOLOR=RGB(210 210 210),
PRINT
PROCESSDATE AS ''
DESCRIPTION AS ''
AMOUNT/D30.3B AS ''
COMPUTE COMMENTS/A15 = IF COMMENTS EQ '2BCLR' THEN 'To be cleared' ELSE IF COMMENTS EQ 'CLR' THEN 'Cleared' ELSE IF COMMENTS EQ 'RES' THEN 'Researching' ELSE COMMENTS; AS 'Comment'
COMMENTDATE AS ''
BY DAYSKEPT AS ''
HEADING
" "
"Proof Items"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='C size sheet',
LEFTMARGIN=0.750000,
RIGHTMARGIN=0.750000,
ORIENTATION=LANDSCAPE,
$
TYPE=TITLE,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N1,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N2,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(*),
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=HEADING,
OBJECT=TEXT,
FONT='TAHOMA',
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.167,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.750,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.167,
$
TYPE=GRANDTOTAL,
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.602778,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.027778,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=2.405556,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=2.000000,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=2.100000,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.555556,
JUSTIFY=RIGHT,
$
ENDSTYLE
END
SET COMPONENT='report3'
-*component_type report
ENGINE SQLORA SET DEFAULT_CONNECTION AUDIT_APP
SQL SQLORA PREPARE SQLOUT FOR
-INCLUDE app/maintaintaac_shares_total.sql
END
TABLE FILE SQLOUT
PRINT
DESCRIPTION AS ''
PROCESSDATE AS ''
SHAREAMOUNT/D30.3B AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='C size sheet',
LEFTMARGIN=0.750000,
RIGHTMARGIN=0.750000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
COLUMN=N1,
JUSTIFY=LEFT,
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=2.305556,
JUSTIFY=LEFT,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=3.450000,
JUSTIFY=RIGHT,
STYLE=BOLD,
$
ENDSTYLE
END
 


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Guru
posted Hide Post
*sigh*

Copy this code into document composer. It does work.

 
-* File newfex
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(1.042 8.125), DIMENSION=(3.958 2.188), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.958in; HEIGHT: 2.188in; TOP: 8.125in; LEFT: 1.042in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT CAR
FOOTING
"informationbuilders.com"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=FOOTING,
URL=www.informationbuilders.com,
$
ENDSTYLE
END
COMPOUND END
 


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Gold member
posted Hide Post
J: I tried what you said, but "informationbuilders.com" hyperlink coming in first page only. I want this link in every page as a Footer.


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Guru
posted Hide Post
That is strange because when I copy that code and paste it into text editor, it prints at the bottom of two pages (it would be more if there was more data.

Try copying the exact code into a .fex page (document composer or not) and double check because my output is two pages with the link at the bottom of both.

What pdf reader are you using to view the pdf's?
Can anyone else verify this for santu...

This message has been edited. Last edited by: J,


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Virtuoso
posted Hide Post
quote:
ON TABLE PCHOLD FORMAT PDF


Don't you need "HOLD", rather than "PCHOLD", in table requests within the scope of a COMPOUND block?
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Guru
posted Hide Post
I don't know how it was before 7.7.03, But the document composer format (COMPOUND LAYOUT PCHOLD FORMAT PDF) overrides the individual TABLE FILE formats. I could do ON TABLE PCHOLD FORMAT HTML and it would still be PDF in the final output.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Gold member
posted Hide Post
J: in below code the report's property attribute(Size and Overflow) is Fixed. If you change this to overflow then the report data will come as a flow and footer will come at the end of 2nd page.

-* File newfex
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(1.042 8.125), DIMENSION=(3.958 2.188), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.958in; HEIGHT: 2.188in; TOP: 8.125in; LEFT: 1.042in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT CAR
FOOTING
"informationbuilders.com"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=FOOTING,
URL=www.informationbuilders.com,
$
ENDSTYLE
END
COMPOUND END

Compound layout will be useful when we want to merge different formats of reports into one. You need to mention the report type in the compound layout in which format you want the merged report.


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Gold member
posted Hide Post
anyone?


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Platinum Member
posted Hide Post
You could do it this way either added on eachpage or on a master page:
-* File newfex2
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
OBJECT=STRING, NAME='text1', TEXT='<font face="TREBUCHET MS" size=10>Important Legal Information<BR>HTTP://www.yahoo.com</font>', POSITION=(1.354 0.625), MARKUP=ON, WRAP=ON, 
DIMENSION=(3.333 0.417),  METADATA='WORD-WRAP: break-word; FONT-SIZE: 10pt; HEIGHT: 0.417in; FONT-FAMILY: Trebuchet MS; POSITION: absolute; LEFT: 1.354in; Z-INDEX: 1; TOP: 0.625in; WIDTH: 3.333in', $
COMPONENT='DfltCmpt1', POSITION=(0 0), DIMENSION=(0 0),  $
END
SET COMPONENT='DfltCmpt1'
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
IF READLIMIT EQ 1
ON TABLE SET PREVIEW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
END
COMPOUND END



WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Expert
posted Hide Post
Santu, Have you found your final solution to this?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
Alex & Doug: Thankyou for your reply. I tried as Alex said. It is displaying like below

Important Legal Information
HTTP://www.yahoo.com


when i click on "Important Legal Information" then nothing is happening but if i place my mouse cursor on "http://www.yahoo.com" then it is acting like a hyperlink.

Is it possible to make the text as a hyperlink and hide the URL(
HTTP://www.yahoo.com
)?


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Platinum Member
posted Hide Post
You can include hyperlinks in your report components but it does not appear that you can make the actual independent text added in the document composer a hyperlink. If you say "Click on the link below for important legal information" and add a URL as I did it will display as a link. I would suggest that you enter a case for a NFR on the tech support site.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Guru
posted Hide Post
Why don't you create a dummy report with pretty much no output in the bottom right corner or somewhere out of the way and make it fixed. You can have your other reports set to overflow:

 -* File newfex
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(5.623 9.900), DIMENSION=(2.370 0.602), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 2.37in; HEIGHT: 0.602in; TOP: 9.9in; LEFT: 5.623in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
BY HIGHEST 10 CAR NOPRINT
FOOTING
"informationbuilders.com"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=FOOTING,
URL=www.informationbuilders.com,
$
ENDSTYLE
END
COMPOUND END 


This will put the link at the bottom of 10 pages (According to the by highest). You can make the by highest variable and all you need to figure out is how many pages your pdf document is going to be. (probably by doing a calculation on the &LINES amount).


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Guru
posted Hide Post
BTW there is a "Sizing Requirement" option for the overflow reports so that you can leave enough space at the bottom for your 'hyperlink report'. Now all you have to figure out is how to make the dummy report show up on all your pages. Maybe there is an option for that?


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Platinum Member
posted Hide Post
Put it on the master page but that seems like a little overkill.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Guru
posted Hide Post
Thats it. Put "Important Legal info" into an image. Have a URL attribute for the image. Put the image at the bottom of the master so it will show up on every page. Set the report frame's sizing requirement to the size of the image so that enough space will be left over for the image on every page.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Gold member
posted Hide Post
Hi Alex/J,

Thanks for your reply.

I was tried to insert the report at the end of the page as a footer as J said but the data which is there in the inserted report is not repeating for every page.


As Alex said i tried to change the code of 'DfltCmpt1' component which came by default for Master page but when i open my fex code with document composer, then 'DfltCmpt1' component code going to default state. It is erasing whatever i did for DfltCmpt1 component.

As J said, I added the image to the end of the master page and added the URL attribute to the image. but hyperlink is not working for image. I wrote code like below.

OBJECT=IMAGE, NAME='image1', URL='HTTP://WWW.YAHOO.COM', IMAGE=logo.gif, POSITION=(0.729 0.208), DIMENSION=(2.393 0.556), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 2.393in; HEIGHT: 0.556in; TOP: 0.208in; LEFT: 0.729in', $

Is it the right way to add the URL attribute to the IMAGE?

Thanks in advance


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Report This Post
Platinum Member
posted Hide Post
I do not think you can make a hyperlink out of either an image or specific text. I don't see any reference to doing that in the Document Composer manual. You can add a hyperlink to a report and include the report in you document or you can do it the way I suggested earlier. If this is something you can't live without I suggest you open a case with CSS.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Guru
posted Hide Post
Since there is a link, does this have to be pdf?

Can it be a pdf embedded in an html composer page or just an html report to begin with?

You could have everything but the link in the pdf file so that they can still print it off easily but then have the link in the html.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] How to make the text as hyperlink in document composer

Copyright © 1996-2020 Information Builders