Solved: SSRS 2008 Hyperlink to Server Folder

Create Account

Microsoft SQL Server

Questions

Followers

Top Experts

ahf50🇺🇸

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!

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION

EugeneZ🇺🇸

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

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

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

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.

Microsoft SQL Server

Questions

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.