Solved

SQL Server Report Builder Hyperlink Column Not Click-able?

Posted on 2014-02-11
5
1,627 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
[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
  • 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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

688 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