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.