SSRS 2008 Hyperlink to Server Folder

ahf50
ahf50 used Ask the Experts™
on
I have a SSRS report that only outputs one text box.  I would like to make this text box a hyperlink to open Windows Explorer directly to network folder on our server (i.e.  G:\FolderName\SubFolderName).

I have tried to do this by going into -> Right-click on text box, Text Box Properties, Action, Go to URL (radio button selected), Select URL textbox.

I've tried typing a number of possible solutions in the Select URL textbox with no luck.

Has anyone tried doing this and had it work?

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
SQL SERVER EXPERT
Commented:
try to use UNC path:
\\servername\sharedFolder  just make sure to set this share permissions
ahf50

Author

Commented:
Tried that with no luck.  It behaves as a hyperlink (hand shows) but when I click on it, nothing happens... and I have permissions to the folder that I'm trying to access.

Thanks for the suggestion.
ahf50

Author

Commented:
Eugene Z,

Actually it does work, but not from the SSRS preview window.  The report needs to be exported to PDF, then the link will work.

If you know of anyway to have it work from the SSRS preview window, that would be more preferrable.

Thanks!
ahf50

Author

Commented:
The problem only lies when in the BI Development Studio environment.  When I deploy the report to the SSRS server and run from there, it works fine.  I think I'm good to go.  

Thanks for all your help on this.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial