SSRS, SQL Server and Clickable URLs

I am using SQL Server 2008 r and the BIDS that comse with it to create an SSRS report.

In a table on SQL Server I have a table type containing varchar data type that includes link like this... <a href="http://link.com">Click Me</a>

In SSRS the way I wanted it to work was to display in the dataset a link that says Click Me and when you click it it follows to the URL I specified in the table data. Instead it's just spitting back at me the charactert data.

Is there a way to make SSRS look at the URL in the data and display as HTML and not just display as character?
sonofstimpy1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
I had that question - I don't have SSRS handy to test, and I got the impression you could do that for the detail records, but I wasn't sure.

I found another walk-through that seems to work with that A tag as you've got it set up:

http://stackoverflow.com/a/14879036/8114
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Can you use these steps to add a clickable link to your report?

http://technet.microsoft.com/en-us/library/dd239346.aspx

It looks like it just accepts the URL, not the whole HTML segment, so you may have to manually remove the "A HREF=" tags for it to work as expected.
0
 
sonofstimpy1Author Commented:
Thanks for commenting ryan

Thing is, I think this only applies for one URL, and I have a report that returns multiple records that include their own seperate URLs.
0
 
sonofstimpy1Author Commented:
Thanks Ryan!!!!
0
All Courses

From novice to tech pro — start learning today.