Text Mode Help: Create Friendly URL using CONCAT(

[Matt_McC]

Hey community - does anyone know of a way to use the CONCAT feature combine elements to form a hyperlink but only show a shortened view in the report? I would like to do this without using a custom field.

displayname=User Directory
link.isnewwindow=true
linkedname=direct
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=emailAddr
querysort=owner:emailAddr
textmode=true
usewidths=true
valueexpression=CONCAT("https://userdirectory.company.com/users/",{owner}.{uniqueUser})
valueformat=HTML

at the moment it shows:

• https://userdirectory.company.com/users/uniqueuser

what I want to show:

• uniqueuser (but retain the link)

[MatFix]

Any chance someone got input on this?