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.

 All Forums
 Development Tools
 Reporting Services Development
 Linking PDF Documents to Reporting Services

Author  Topic 

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-12-01 : 01:48:34
Hi Everyone I have been having this problem for awhile. We input the clients data intot he database and we Scan their documents in PDF format. What I would like to do is when the user runs a report on reporting services that not only would the client data would show but a link to their Electronic file. How exactly do you do that. i know its throught the Jump URL, but now sure how to put the address link to each individual file. Because we will be scaning the documents to a folder on the server

C:\Documents and Settings\Administrator\My Documents\ScannedDocuments

can anyone help please

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-01 : 06:36:51
You need some mechanism (such as a table) that contains the document names associated with a client and possibly the path. I would suggest using the UNC path unless you are absolutely sure the scanned documents will always be local.

If not in a table, SSRS has no idea what is stored on a hard drive

John
It's a small world (but I wouldn't want to paint it)
Go to Top of Page
   

- Advertisement -