My preferred method is to wrap this up into a custom code function such as
Function OpenURL(ByVal URL As String) As String
In your report, you can then just set the navigation property to jump to a URL of a website:
Or to the path of a the drillthrough report:
If you have parameters that you need to pass in, you can add these into the URL either fixed or dynamic:
=Code.OpenURL(“http://[Your Server]/ReportServer?/Folder/ReportName&rs:Command=Render &MyFirstParam=Value1&MySecondParam=” & Fields!MyField.Value)
Please note that this will not work in the BIDS development environment, it will only work once you have deployed the report to the Report Server.
Hi… I found your blog from ExpertExchange in the chapmandew post.
Your blog is very good!
I hope to come here more times!!
Thanks so much for this post! This worked perfectly for me, except I just had to replace the single-quotes and double-quotes after copying and pasting into my report. I knew I could probably use JScript, but I just didn’t know how.