SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to open a URL in a new window in SSRS report?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 02/21/2014 :  07:10:45  Show Profile  Reply with Quote
I want to open a pdf file in a new window by clicking on its URL in SSRS reoprt. I heard that it is possible with Java script. So I tried with ="javascript:void window.open('yoururl&rs:Command=Render"')" in the SSRS expression. It is working only for https and http.

But the URL which I want to open is as follows. \\ourcompanyname.local\systems\documents\abcd.pdf
Can anyone please help me to resolve this issue. It is on high priority. please reply ASAP.

As a database developer, I will be very happy if it is possible with SQL script.

If not please help me with some java script.

Thanks in advance.


Constraint Violating Yak Guru

277 Posts

Posted - 02/21/2014 :  08:48:58  Show Profile  Reply with Quote

insert a text, name it to "Link to URL" (< example). Then right click, Textbox properties. A window will pop out. On the left hand side Menu, click on "Action". Make sure you check the box "Go to URL". And finally copy/past a valid url to that function textbox.

Joins are what RDBMS's do for a living
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000