Hyperlink for Database Stored PDF

• nathanfields

  Old Hand

  Points: 347

  More actions

  March 21, 2022 at 1:57 pm

  #4003430

  I am needing to pull a database stored PDF and hyperlink to the PDF within another SSRS or Crystal Report.  I can hyperlink to a URL if the pdf is stored in internet file server but if the PDF is within a SQL Database I cannot get either Crystal or SSRS to hyperlink to the file.

  Any ideas?

  • This topic was modified 3 years, 3 months ago by nathanfields.

• ratbak

  Default port

  Points: 1417

  More actions

  March 21, 2022 at 3:27 pm

  #4003476

  When you say "PDF is within a SQL Database" do you mean as a blob (e.g., varbinary column)? You can't hyperlink to a location that doesn't exist.  Or are you using FileStream? But it should work with Filestream if I/O streaming access is enabled &  SSRS or Crystal can access the folder(s) and has rights to the folders/files.

  https://stackoverflow.com/questions/25389538/ssrs-2008-create-url-link-to-pdf-file-on-file-server-for-each-cell-in-report-ta