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>,

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?

no one?

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...

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?

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

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,

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.

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> 

'

Can you share complete code that you are trying out.

Santu, you should try a suggestion out before you assume. Ebaig's solution works.

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
 

*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
 

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.

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,

quote:

ON TABLE PCHOLD FORMAT PDF

Don't you need "HOLD", rather than "PCHOLD", in table requests within the scope of a COMPOUND block?

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.

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.

anyone?

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

Santu, Have you found your final solution to this?

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

)?

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.

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).

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?

Put it on the master page but that seems like a little overkill.

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.

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

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.

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.