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
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.
thanks it worked. :)
ReplyDeleteWelcome, Much appreciated comment.
DeleteThanks for posting. I was making this more complicated than it needed to be.
ReplyDeleteWelcome, Much appreciated comment.
DeleteThis 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.
ReplyDeleteThanks, Yes that's correct.
DeleteHey can u please share the URL when I am trying to give 4 report parameters to the URL for drill through action.
ReplyDeleteHi, 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?
ReplyDeleteYour 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.
ReplyDeleteI 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..
ReplyDeleteI am definitely enjoying your website. You definitely have some great insight and great stories.
ReplyDeletejohn faraday
Thanks.. It worked
ReplyDeletethis is nice but is there a way to just get the results of the URL expression in the text box?
ReplyDeleteSeveral many thanks for share your blog website right here. Best Annual Report Design
ReplyDeleteOutstanding in addition to effective suggestion by the author of this blog are genuinely sensible to me. Packaging Design Perth
ReplyDeleteOutstanding as well as powerful tip by the writer of this blog are really handy to me. Web Designers Perth
ReplyDeleteGreat blog ! I am impressed with suggestions of author. Display Banners Perth
ReplyDeleteI found one successful example of this truth through this blog. I am going to use such information now. Design Agency
ReplyDeleteAwesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. offshore software development services
ReplyDeleteI 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
ReplyDeleteNow 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.
ReplyDeleteIELTS Coaching in chennai
German Classes in Chennai
GRE Coaching Classes in Chennai
TOEFL Coaching in Chennai
spoken english classes in chennai | Communication training
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.
ReplyDelete| Certification | Cyber Security Online Training Course|
Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course|
CCNA Training Course in Chennai | Certification | CCNA Online Training Course|
RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai|
SEO Training in Chennai | Certification | SEO Online Training Course
This comment has been removed by the author.
ReplyDeleteFor this situation, wooden boxes come as the most ideal alternative. Essential Oil Boxes
ReplyDeleteThat is really nice to hear. thank you for the update and good luck. Norstar
ReplyDeleteMany 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/
ReplyDeleteMore 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/
ReplyDeletewow 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
ReplyDeleteThanks for this blog, keep sharing your thoughts like this...
ReplyDeleteWhat is MERN Stack
How Does MERN Stack Work
wow this saintly however ,I love your enter plus nice pics might be part personss negative love being defrent mind total poeple , Data recovery
ReplyDeleteIT 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
ReplyDeleteIn short, ShareMouse License Key is an excellent program that allows its users to manage several computers from a single mouse and keyboard. Website
ReplyDeleteBest 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
ReplyDeleteThis comment has been removed by the author.
ReplyDelete