Sql-server – sp_whoisactive in SSRS

sql server 2014ssrs-2014

I have setup sp_whoisactive as a report in SS Reporting Services so people less familiar with SSMS can run it and see what is happening when needed. I have it working good and BUT I can't seem to figure out how to show the "sql text" column as a hyperlink in SSRS as it's shown in SSMS. Anyone have any ideas?

fyi, we ended up doing this:

enter image description here

Best Answer


... add a hyperlink

On the Action tab, select Go to URL. An additional section appears in the dialog box for this option.

In Select URL, type or select a URL or an expression that evaluates to a URL, or click the drop-down arrow and click the name of a field that contains a URL.

For an item published to a report server configured for native mode, use a full or relative path. For example, http:///images/image1.jpg.

For an item published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example, http:////Documents/images/image1.jpg.

Click OK.

After you add a hyperlink

(Optional) The text is not automatically formatted as a link. For text, it is helpful to change the color and effect of the text to indicate that the text is a link. For example, change the color to blue and the effect to underline in the Font section in the Home tab of the Ribbon.

To test the link, click Run to preview the report, and then click the report item that you set this link on.