How to create a hyperlink in SQL Server Reporting Services

June 12, 2009 — Anubhav Goyal

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.

Posted in sql server 2005, ssrs. 14 Comments »

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

  1. jazzy Says:
    February 17, 2010 at 6:44 am

    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

    Reply
  2. kiddin rocky Says:
    December 7, 2011 at 9:20 am

    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?

    Reply
    • Anubhav Goyal Says:
      December 8, 2011 at 2:27 am

      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.

      Reply
  3. Suhail Quadri Says:
    April 9, 2012 at 9:27 am

    it dint work for me 😦

    Reply
  4. vskfu Says:
    October 19, 2012 at 10:57 am

    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?

    Reply
  5. Raja Says:
    November 5, 2012 at 11:05 am

    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

    Reply
  7. nutra green coffee Says:
    July 2, 2013 at 4:56 am

    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.

    Reply
  8. nuva lift review Says:
    July 2, 2013 at 11:15 am

    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.

    Reply
  9. electric Says:
    July 9, 2013 at 6:35 am

    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!

    Reply
  10. garcinia cambogia Says:
    August 2, 2013 at 9:57 pm

    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!

    Reply
  11. strategy trader Says:
    August 6, 2013 at 2:48 am

    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.

    Reply
  12. CCWNC DELELOPER Says:
    January 23, 2014 at 7:16 pm

    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

    Reply
  13. livescore Says:
    July 30, 2018 at 5:03 pm

    Wow, fantastic website layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your site is excellent, as well as the
    content!

    Reply

Leave a comment

«

»