Solved

SQL Server Report Builder Hyperlink Column Not Click-able?

Posted on 2014-02-11
5
1,586 Views
Last Modified: 2014-02-18
I have a report with a hyperlink column that works in SQL Report Builder 3.0 desktop, but not on the website where it's shown.

1. 'Website_Domain' field is the shortened URL (domain) is the text seen in the Report column
     (technet.microsoft.com)

2. 'Website_Url' field is the full length URL which is used in the 'Go to URL' properties
     (http://technet.microsoft.com/en-us/library/ms159106.aspx)

['Website Link' Expression]
=Fields!Website_Domain.Value

['Website Link' Column Properties]
Action = Go to URL
Selected URL: [Website_Url]
0
Comment
Question by:WorknHardr
  • 3
5 Comments
 
LVL 19

Expert Comment

by:strivoli
ID: 39853098
Which browser and version are you using when accessing the report?
0
 

Author Comment

by:WorknHardr
ID: 39853148
I use both Firefox and IE9
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39853310
Can you try adding an additional column to the table and set up the action on that one to see if that helps?  (I came across people explaining similar issues and in some cases recreating the same report worked.)
0
 

Accepted Solution

by:
WorknHardr earned 0 total points
ID: 39856790
Update:

Still not working your way either. I have another report using the following expression and it works!

      =Iif(LEN(Fields!Website_Url.Value) > 8, "Web Link", "")

Solution:

1. Use the following expression and replace the static Text with a Field Value:

      =Iif(LEN(Fields!Website_Url.Value) > 8, Fields!Website_Domain.Value, "")

2. Set 'MarkupType' to 'None' (...links don't 'click' if set to 'HTML')

      MarkupType = None
0
 

Author Closing Comment

by:WorknHardr
ID: 39866903
Discovered working solution else where and thought I would share it here, thx EE
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
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 …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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