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 |
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 serverC:\Documents and Settings\Administrator\My Documents\ScannedDocumentscan 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 driveJohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|