Search This Blog

Adding Hyperlink in Text Box in SSRS

Adding Hyperlink in Text Box in SSRS

Sometime you have a Requirement in your Report  in which you want to add a hyperlink toText Box fields i.e.
Clicking on field Name will navigate you to new Report or Some Website.

For this you can select the Text Box which  you want as Hyperlink to Report or URL

Right Click on Selected TextBox-TextBox Properties-Action 

By Default it will be None
Change it to Go to Url 
Select URL-click on fx -
Write your URL Name eg www.google.com
Click ok 

IF you want to navigate to any Report 
Select Go to Report
ReportName eg Test.rdl
click ok

This is how you can add Hyperlink to any TextBox on your Report.

Note: In order to Pass some Fields value with the Link you can write in Expression like this
="http://localhost/ReportServer?/ReportName&EmpID="
 &Fields!Empid.Value 
Where Empid is the selected Field to be send along with the URl,
 & is used to concatenate field value to URL.

34 comments:

  1. Thanks for posting. I was making this more complicated than it needed to be.

    ReplyDelete
  2. This is perfect! Why? Most things I've read online says to use JavaScript window.open. The problem with that is that it does not print correctly. With a plain link like this, you still have the link in PDF which is perfect.

    ReplyDelete
  3. Hey can u please share the URL when I am trying to give 4 report parameters to the URL for drill through action.

    ReplyDelete
  4. Hi, thanks for the post. However I have a network path value in one of the data field of my report and I need to give a hyperlink to that so that on click of the link user will be taken to the respective network path. is this possible in SSRS?

    ReplyDelete
  5. Your blog content is exactly what I need, I like your blog, I sincerely hope that your blog is a fast-growing traffic density, and to help promote your blog, we hope you blog updates and place can always be colorful. Thanks for the sharing. SQL Server Reporting Services is a reporting tool that comes free with SQL Server. With SSRSyou can produce formatted reports with tables of data, graphs, and charts.

    ReplyDelete
  6. I found your blog very interesting and very informative. I think your blog is great information source & I like your way of writing and explaining the topics.SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft Readmore..

    ReplyDelete
  7. I am definitely enjoying your website. You definitely have some great insight and great stories.
    john faraday

    ReplyDelete
  8. this is nice but is there a way to just get the results of the URL expression in the text box?

    ReplyDelete
  9. Several many thanks for share your blog website right here. Best Annual Report Design

    ReplyDelete
  10. Outstanding in addition to effective suggestion by the author of this blog are genuinely sensible to me. Packaging Design Perth

    ReplyDelete
  11. Outstanding as well as powerful tip by the writer of this blog are really handy to me. Web Designers Perth

    ReplyDelete
  12. Great blog ! I am impressed with suggestions of author. Display Banners Perth

    ReplyDelete
  13. I found one successful example of this truth through this blog. I am going to use such information now. Design Agency

    ReplyDelete
  14. Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. offshore software development services

    ReplyDelete
  15. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. text messaging service for business

    ReplyDelete
  16. Now I know that I was reading a blog with a post that is very commete. Thank you for sharing the information you post. I just subscribe to your blog. This is a great blog.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. For this situation, wooden boxes come as the most ideal alternative. Essential Oil Boxes

    ReplyDelete
  19. That is really nice to hear. thank you for the update and good luck. Norstar

    ReplyDelete
  20. Many association's web servers has been compromised due to SQL Injections, including enormous names which I might not want to make reference to here, you can look through it effectively on Internet. https://onohosting.com/

    ReplyDelete
  21. More modest ventures might be served by the building range of abilities moved by the DBA. You should go over the DBA's experience and check for preparing and involvement with database plan and execution. Past experience on a database creation venture would be great.https://hostinglelo.in/

    ReplyDelete
  22. wow this saintly however ,I love your enter plus nice pics might be part personss negative love being defrent mind total poeple , Help With Data Analysis For Dissertation

    ReplyDelete
  23. Thanks for this blog, keep sharing your thoughts like this...
    What is MERN Stack
    How Does MERN Stack Work

    ReplyDelete
  24. wow this saintly however ,I love your enter plus nice pics might be part personss negative love being defrent mind total poeple , Data recovery

    ReplyDelete
  25. IT security professionals: Learn how to identify and repair vulnerabilities in your wireless networks. This course is part of our Certified Ethical Hacker. Wifi Hacking Online

    ReplyDelete
  26. In short, ShareMouse License Key is an excellent program that allows its users to manage several computers from a single mouse and keyboard. Website

    ReplyDelete
  27. Best first: I wish you a wonderful Christmas, fragrant with pine and cookies, filled with carols and giggling and plastic police car chases, with hugs Unique Christmas Wishes

    ReplyDelete
  28. This comment has been removed by the author.

    ReplyDelete