[Trac] How to render Trac Report's query result as hyperlink?

I would like to have a hyperlink in my Trac Report's query result to
link to external site.

For example:
Select ("http://externalsite/lookupissue.jsp?number=" || tc1.value) AS
Issue from ticket t
LEFT JOIN ticket_custom tc on t.id = tc.ticket and tc.name = 'number';

It would be grand if the http://externalsite/lookupissue.jsp?number=.....
can be rendered as a link.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users@...
To unsubscribe from this group, send email to trac-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---