Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to Link a Report with a Document Folder

Beantwortet How to Link a Report with a Document Folder

  • Wednesday, July 11, 2012 1:28 AM
     
     
    Sign In to Vote
    0

    Hi Guys,

    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.

    Regards

     

All Replies

  • Wednesday, July 11, 2012 1:58 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hi There

    Thanks for your posting. Please right click on your textbox and go to action and then go to URL and paste something like this

    ="file:\\Yourserver\Yourfolder\help.doc"

    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"

    Many Thanks

    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
     
     
    Sign In to Vote
    0

    Hi Syed,

    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 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hi There

    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

    file://servername/folder

    For more info

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/926b50ae-3062-4e32-83b4-fd2dcef0ac58/

    Many thanks

    Syed

     
  • Thursday, July 12, 2012 12:43 AM
     
     
    Sign In to Vote
    0

    Hi Syed,

    I have tried this, even with the servername like file:\\servername\folder\document.ext and I even tried like file://servername/folder/document.ext

    but it doesn't work. I don't know what I'm missing.

    Thank you very much for your time, I will let you know if I figure the problem.

     
  • Tuesday, July 17, 2012 7:31 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Reddy_123,

    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.  

    Regards,
    Mike Yin