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]
WorknHardrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
WorknHardrAuthor Commented:
Discovered working solution else where and thought I would share it here, thx EE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.