September 23, 2011 at 10:17 am
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?
September 23, 2011 at 11:21 am
Hi,
Have a look at the following: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/541a46fc-4288-49f2-96a2-0ac45c18f5bd/
I think you'll find what you are looking for there...
Martin.
September 23, 2011 at 1:01 pm
Great find. Thank you very much. Using the URL action type with this syntax worked.
="FILE:\\someserver.com\somefolder\somePDFfile.pdf"
September 23, 2011 at 2:19 pm
tonylavoie (9/23/2011)
Great find. Thank you very much. Using the URL action type with this syntax worked.="FILE:\\someserver.com\somefolder\somePDFfile.pdf"
perfect 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply