Pulling from a data source and displaying as hyperlink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe H - 30 Jan 2008 23:08 GMT

I have a table with a hyperlink. When I display the data by pulling from a
data source - I want the hyperlink comming from the database to actually
show up as a clickable hyperlink so I can pass it on with parameters to
reporting services.

When it displays it, it has the word "Hyperlink:\www..." instead of
converting it to an actual hyperlink. I'm guessing there is something
similar to do as you would when pulling HTML from a data source where you
tell it to not actually display the HTML but convert it...

Reply to this Message

Gary''s Student - 31 Jan 2008 00:15 GMT

Hi Joe:

Sometimes hyperlinks drawn from data sources are not directly "click-able".
Examples are hyperlinks displayed by Data Validation or the result of
=VLOOKUP().

If A1 contains a non-click-able link like:

http://www.cnn.com

then in another cell enter:

=HYPERLINK(A1) to get a click-able version

Signature

Gary''s Student - gsnu2007c

> I have a table with a hyperlink. When I display the data by pulling from a
> data source - I want the hyperlink comming from the database to actually
[quoted text clipped - 5 lines]
> similar to do as you would when pulling HTML from a data source where you
> tell it to not actually display the HTML but convert it...

Reply to this Message