Wednesday, July 11, 2012 1:28 AM
I am new to SSRS, I have a reqirement to link a document folder (Contains word,PDF,TIFF)to a report.
I have a DocID column in report and the file names in the document folder starts with this DocID, I need to link the docID in the report to that file,
as when I click the DocID link in the report I would be able to read that document in the folder, is it possible in anyway?
Could anyone please help me finding a solution to this.
Thank you for your time.
Wednesday, July 11, 2012 1:58 AMModerator
Thanks for your posting. Please right click on your textbox and go to action and then go to URL and paste something like this
You can dynamiclly link your file by using your dataset field like this if your document number has same id as your dataset filed
="file:\\Yourserver\Yourfolder\" +fields.DocID.value +".doc"
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Wednesday, July 11, 2012 2:43 AM
Thank you for your quick response,
I did exactly what you've mentioned in the screen shots but when I click on the document nothing happens.
screen shots for your reference, please tell me if I am missing anything.
Wednesday, July 11, 2012 4:06 AMModerator
Is H is your network drive ? Please try to put machine name instead of H Do not put : .
You can see taht I have put server name and dont have any semicolon etc. If it is still not working then try
For more info
- Proposed As Answer by IceQB (MCITP, MCC) Wednesday, July 11, 2012 6:47 AM
Thursday, July 12, 2012 12:43 AM
Tuesday, July 17, 2012 7:31 AMModerator
Thanks for your posting.
Have your figured out the issue yet? It's a little odd that neither the file:\\server\folder\document.doc nor the file://server/folder/document/doc works. Please make sure you were using the correct extension for the documents (like .doc, .pdf and so forth) rather than the .ext in the similar thread you referenced. Meanwhile, please check whether the documents can be opened properly by copying the URL into the Internet Explorer address bar.
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Monday, July 23, 2012 11:28 AM