Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tonylavoie
Starting Member
1 Post |
 Posted - 2011-09-23 : 12:22:18
|
| I have a report that has Customer Order info. Within that report is the Customer Order number. We store all Customer Order paperwork online in pdf files on our network. What I would like to do is allow a user to click on the Customer Order number in the SSRS report and that would link to the pdf file on the network drive. The pdf files are named in a manner where the customer order number is the actual name of the file so its easy to link the customer order number in the database to the actual customer order pdf file. I tried to use the Action/URL option but it requires a HTTP protocol but the file is not on a web page but rather a network drive like \\Entsrsql04\controls\pdf files . Any suggestions on how to allow a user to click on an item in SSRS and have it point to a stored file on a network drive?Thanks |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-10-07 : 05:34:40
|
| One option is to build the filepath to the file in your SQL Statement - something like,'\\Entsrsql04\controls\pdf files\orderno_' + CustomerOrderID as OrderLinkand then when you're setting up your action for your textbox in the report use 'Open URL' and select that OrderLink field from your query as the URL path.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
 |
|
|
|
|
|
How to link(action option) to a stored pdf on netw