Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects -Webi - Embed a Hyperlink into a Cell in a Report

This article explains how to create a HTML link that displays a value that can be clicked on to open a web page that corresponds to the value displayed.

This article explains how to create a HTML link that displays a value that can be clicked on to open a web page that corresponds to the value displayed.

There are two types of links that can be embedded into a report: a URL or an HTML code snippet.

URL Method

Using the URL is ungainly, but it can export to Excel. The URL is constructed in a variable to create a fully-qualified (UNC or HTTP) path to the document to be opened.

Example

<My URL>="\\{Server name}}\{Share & folder Path}\" &<Control No>&".PDF"

HTML Method

An HTML code snippet makes a more visually pleasing hyperlink and uses less space on the report; however, it does not export to Excel properly.

  1. Format the cell where the link will be placed to read as HTML.

    <htmlentity></htmlentity>
  2. Build a variable using the URL above to create the HTML code.

    <My HTML>="<A href=" & Char(34) & <My URL> & Char(34) & ">" & <Control No> & "</A>"

    The Char(34) functions are used to place quotation marks into the string.




Keywords:IRF, SDW, AURA, HTML, link, GEMS   Doc ID:19630
Owner:James I.Group:University of Chicago
Created:2011-08-07 19:00 CDTUpdated:2017-03-06 11:35 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  3   3