Help with Hyperlink/Custom Text field

[kidwispa]

Hi,

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.

Thanks

[Deanicus]

Hi kidwispa

I've attached an example report which should show you how to do it

Particularly you are interested in the url section of an element. This can be found in style/links of an element

In this example I used a formula to generate a URL using the "link" field from my datasource. I could only get it to work by combining "http://" and my field. If your field already contains this I would suggest trimming it off in SQL so it will work