• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1722
  • Last Modified:

SQL Server Report Builder Hyperlink Column Not Click-able?

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
WorknHardr
Asked:
WorknHardr
  • 3
1 Solution
 
strivoliCommented:
Which browser and version are you using when accessing the report?
0
 
WorknHardrAuthor Commented:
I use both Firefox and IE9
0
 
ValentinoVBI ConsultantCommented:
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
 
WorknHardrAuthor Commented:
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
 
WorknHardrAuthor Commented:
Discovered working solution else where and thought I would share it here, thx EE
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now