Solved

SQL Server Report Builder Hyperlink Column Not Click-able?

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

3 Use Cases for Connected Systems

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

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 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