Solved

SSRS, SQL Server and Clickable URLs

Posted on 2014-02-13
4
639 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
  • 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now