Solved

SSRS, SQL Server and Clickable URLs

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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 …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 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