December 16, 2013 at 3:41 pm
In a SSRS 2008 R2 existing dashboard application, I will be adding help files in the form of PDF files added to ssrs report. To be able to add these additional links for the users to access, I have the following additional questions to ask you which are:
1. I want to access these PDFs from the file directory path that is on my workstation. The PDF files are in a directory structure that looks like:
C:\\Images\test.pdf. Thus can you tell me how to access the PDF documents that are on my workstation?
2. I will move the pdf files to a test report server and then to a production report server. Thus can you tell me:
a. How to reference the pdf files on the test and production report server?
b. How can I make the path of the pdf documents be dynamic? Basically the test and production report servers will have a different url?
I know that I could look at the connection string of the data source to determine if the ssrs report is running on the test or prod report server. Basically I would say if the connection string is the test report server then obtain pdf from test report server. If the connection string is the production report server, then I would use a different url.
Thus can you show me some code on how to accomplish my idea and/or how you would setup the dynamic location for the path of the pdf document?
December 16, 2013 at 11:34 pm
The PDFs would need to be uploaded to a web server then linked, or stored in a shared folder with the correct permissions. To create the link on the report follow this http://social.msdn.microsoft.com/Forums/sqlserver/en-US/541a46fc-4288-49f2-96a2-0ac45c18f5bd/open-a-pdf-file-from-a-ssrs-report?forum=sqlreportingservices
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply