How to create a hyperlink in SQL Server Reporting Services

There is no direct option to create a hyperlink in SSRS, however you still can create links. This is how.

When designing the report:
• Open up a text box properties window
• In the Value box enter the display for the link. You can use the expressions too.

When designing the report:

• Open up a text box properties window

• In the Value box enter the display for the link. You can use the expressions too.

• Go to Navigation

• Enable Jump to URL

• In the URL enter =”javascript:void(window.open(‘http://localhost/VBMS2/WorkTray/WorkItemOpen.aspx?T=V&WIS=67B3D3AD-156C-4D52-B46D-87E12827B11F’, ‘_blank’))” . Add the URL you would like to launch.   _Blank, is used to launch the link in a new window.

Note that reporting services will not display the underlined and blue color hyperlinks, one trick is to format the text color to blue and use Font Decoration Underline.

13 Responses to “How to create a hyperlink in SQL Server Reporting Services”

  1. jazzy Says:

    Thanks a lot! If you know, please share, how can you disable the hyperlink conditionally in expressions.
    e.g you can add hyperlink using above method. But if value is space, the hyperlink still shows up. Is there a way to remove hyperlink for specific values.

    thanks a lot

  2. kiddin rocky Says:

    This is what I do too, however I’ve noticed that when the email subscription is sent out, the format is not applied to the email body, so it just looks like text not a link. any ideas?

    • Anubhav Goyal Says:

      Note that reporting services will not display the underlined and blue color hyperlinks, one trick is to format the text color to blue and use Font Decoration Underline.

  3. Suhail Quadri Says:

    it dint work for me 😦

  4. vskfu Says:

    If you export the report to excel it doesnt work and loses the navigation set up. I tricked it to use =Hyperlink(“url”) so that in excel it create it dynamically but it doesnt resolve the link and the whole function comes as text. if i press F2 on link and enter then it turn into a link. any ideas how to do that automatically?

  5. Raja Says:

    Hi,
    I have text box and im trying to link other subreport using Action Go to report, i have not mentioned indent property.
    Link works in BIDS and does not work in IE browser after deployment of reports.
    Please help how to make it work.

    Regards,
    Raj

  6. nutra green coffee Says:

    I’m not sure exactly why but this web site is loading very slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check back
    later and see if the problem still exists.

  7. nuva lift review Says:

    Attractive section of content. I just stumbled upon your site and
    in accession capital to assert that I acquire in fact enjoyed account your blog posts.
    Anyway I’ll be subscribing to your feeds and even I achievement you access consistently rapidly.

  8. electric Says:

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now
    each time a comment is added I get four e-mails with the same comment.
    Is there any way you can remove me from that service?
    Thanks a lot!

  9. garcinia cambogia Says:

    When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time
    a comment is added I get four e-mails with the same comment.
    Is there any way you can remove people from that service?
    Cheers!

  10. strategy trader Says:

    whoah this blog is wonderful i really like reading your posts.
    Stay up the great work! You realize, many individuals are looking around for this information, you could help them greatly.

  11. CCWNC DELELOPER Says:

    How to create a text box in the title area that is a hyperlink (opens in another window)

    1] Drag Text box to title area from Toolbar to the design surface
    2] Then from the ‘Report Data’ pane on the left side, drag any field from the dataset into the text box
    {this is to create a ‘placeholder’ rather than a plain ‘textbox’
    3] Right click on the field, in the textbox, go to ‘Placeholder Properties’
    4] in the action Pane, of the ‘Placeholder Properties’ window, click ‘Go to URL’,
    then click the fx, i.e. expression button, and paste the following into the expression:

    =”javascript:void(window.open(‘http://172.15.189.14:64444/ElectronicForms.aspx’,’_blank’))”

    click [ok] to close the expression window

    5] Go to the ‘General’ tab, in the ‘Placeholder Properties’ widow.
    The Value field will be populated with the name of the field that you dragged into the text box, in step2,
    delete the name of the field. Then click the fx, expression button, and type the following into the expression window:

    =”Click for Help”
    Then click [ok] to close the expression window

    Then click [ok] to close the ‘PlaceHolder Properties’ window


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: