Pulling from a data source and displaying as hyperlink

[Joe H]

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...

 

[Gary''s Student]

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