Forum Stats

  • 3,782,422 Users
  • 2,254,643 Discussions
  • 7,880,075 Comments

Discussions

Navigate to Web Page from report dynamically

Hi,

We have requirement to navigate from OBIEE report column to the web page for the attachments.  We have column called URL which contains Link to the web URL to view/download the invoice details. Each row is different URL I tried to use action link to web page by passing parameters but I couldn't use.

Please suggest. Thanks

Example: If column URL has three values

URL
www.microsofct.com
www.google.com
www.facebook.com

This values will display in the report and when user clicks on it it should navigate to the web page. Is there any way to pass this and there are many rows

Tagged:
Thomas Dodds

Answers

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,397 Gold Crown
    edited Mar 8, 2017 9:32AM

    Hi,

    If your column is a URL set the format in the Criteria tab of your analysis to URL and OBIEE makes all of them clickable and working links.

    It's just a column format as can be number, percentage etc.

    Thomas Dodds
  • Bose Pandian
    Bose Pandian Member Posts: 118
    edited Mar 9, 2017 11:05AM

    Hi,

    If the column has the URL, then just change the Data format of the colum. ( Column Properties -> Data Format -> Custom Data Format)

    @[html]"&lt;a href="@H" target="_blank">"@</a>

    This option will allow the open the URL in the new tab in the browser.

    Hope it helps!

    pastedImage_0.png

    Thanks,

    Bose

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,397 Gold Crown
    edited Mar 9, 2017 12:44PM

    Just a detail: keep in mind a link is supposed to start by " http:// ", so if your values don't have it (all of them) add it to the format of the column.

    The default format "HyperText link (prepend http://)" does it for you, but in this case if you have some with and some without it will not work as http://http:// will not work. So if you have a mix you can fix the quality of data in the source or use a formula in the column to detect if there is the http:// and prepend it if not).

    The default format "HyperText link" will open the links in the same page and it's why the answer above used a custom format taking the "HyperText link" and adding ' target="_blank" ' to open the link in a new window/tab.

This discussion has been closed.