SSRS: How to display a hyperlink in sql services reporting
html, reporting-services, ssrs-2008
Solution
Two approaches, the first assumes data is pre-formatted as a URL (e.g. `https://www.google.com`). The second assumes the URL is contained within some other text (e.g. 'This is a link to Google').
URL Only
Right-click the field in design view, select `Text Box Properties`.
Select the `Action` pane, select the `Go to URL` radio button.
In the `Select URL` textbox, enter the field value expression.
URL Embedded in Text
Double-click the field in design view, then right-click `Create Placeholder`.
In the `Value` textbox, enter the field value expression containing HTML tags.
Under `Markup Type`, check the `HTML - Interpret tags as styles` radio button.
Verify link is displayed when report is run.
Problem
I'm using SSRS for 2008 R2 to display some data-generated reports. In my database table, I have a cell called Remarks. It usually contains links to software defects. The cell is nvarchar(max) and I've added links such as http://stackoverflow.com. However, when the report is displayed, the link is not clickable as expected. What do I need to do make the link clickable? Many thanks for any help. J.