Solved

SSRS, SQL Server and Clickable URLs

Posted on 2014-02-13
4
687 Views
Last Modified: 2014-02-13
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?
0
Comment
Question by:sonofstimpy1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 39856854
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
 

Author Comment

by:sonofstimpy1
ID: 39856985
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
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39857213
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
 

Author Comment

by:sonofstimpy1
ID: 39858025
Thanks Ryan!!!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question