asked on

SSRS 2008 Hyperlink to Server Folder

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!

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ahf50

ASKER

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

ASKER

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!

EugeneZ

try this way http://rubenlaguna.com/wp/2007/04/20/firefox-and-file-windows-unc-paths/

http://en.wikipedia.org/wiki/File_URI_scheme

ahf50

ASKER

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.