Displaying Hyperlinks in a Report

[SuryaLakhani]

Hello,

So I know this can be done using a calculated custom field, but I am trying to do this in the report itself without having to add a calculated field:

displayname=External URL
valueexpression=IF(ISBLANK({DE:Some ID}),"",CONCAT("https://www.google.com?id=",{DE:Some ID}))
valueformat=HTML

This does work functionally and shows a link to the external page, but it shows the entire URL. I am trying to add a Hyperlink here instead of showing the full URL.  

I did try to set up an HTML Tag using the following:
Column1: < a href="

Column2:Above URL

Column 3">link text< /a >

I also used sharecol to combine all the columns into one, but I had no luck! Wanted to see if anyone had any suggestions. Thanks!

[RowvillBh1 · Accepted solution]

Hi @SuryaLakhani ,

Maybe try this. Add the text you want to show as the hyper link in the link.url line- 

displayname=External URL

link.url=customDataLabelsAsString(Hyperlink text)

textmode=true

valueexpression=

IF(ISBLANK({DE:Some ID}),"",CONCAT("https://www.google.com?id=",{DE:Some ID}))

valueformat=HTML

Hope this helps