JRS (CLM 6.0.6.1) - Show text as a clickable URL in Reports
One answer
You have to keep the title and URL as adjacent columns.
Comments
I know that's the case normally, however, if i remove the "Title" column and replace it with the custom expression using SUBSTR(title,1,50) to trim the title length to less than 50 characters, AND have the URL next to this new column, the URL has it's own column.
That's the current design. I do not think that is customisable.
I'm wondering if there is a SPARQL function that will combine my new title with the URL to make a clickable URL. In the custom expression editor there's a URL format.
It looks like you could use SPARQL expressions to construct an HTML hyperlink of the form
<a href='uri'>text</a>
. It looks like RB renders that as an HTML hyperlink in the report results. Watch out for HTML escaping the text part.