Solved

SSRS, SQL Server and Clickable URLs

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 61
Server running out of memory - Something is consuming all the available memory 17 89
sql how to count case when 4 29
monitoring configuration for SQL server DB 32 45
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 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