Even though there is no direct control to place a link in our SQL Server reports, we can use a textbox as a link by providing the navigation property of the text box.
When designing the report:
- Open up a text box properties window
- Go to Navigation
- Enable Jump to URL
- For the URL enter the URL you want to open from your report.
What if you want to open the link in a new window?? (And in some reports the previous case didn’t worked for me 😦 . So I did it in a round way 🙂 )
Enter the below script instead of entering the URL directly.