Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help with Hyperlink/Custom Text field

  1. #1
    Join Date
    Dec 2015
    Posts
    3

    Default Help with Hyperlink/Custom Text field

    Hi,

    I've created a report and have a field from my database that returns a URL.

    What I'm looking to achieve is for this field to actually work as a Hyperlink, and also rather than displaying the URL it displays the custom text "Click here to preview customer images >"

    Can anyone help?

    I hope I've explained it in enough detail but if you need anything else then let me know.

    Thanks


  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    Hi kidwispa

    I've attached an example report which should show you how to do it

    Particularly you are interested in the url section of an element. This can be found in style/links of an element

    In this example I used a formula to generate a URL using the "link" field from my datasource. I could only get it to work by combining "http://" and my field. If your field already contains this I would suggest trimming it off in SQL so it will work
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.