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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-12-16 : 17:40:41
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-17 : 08:01:31
|
| You can use Globals!ReportServerURL to get report url and determine the environment. You can create an expression based on this in a IIF() statement to set the correct path for PDF. You can open it using javascript window.open syntax by using it in jump to url propertyhttp://www.javascripter.net/faq/openinga.htm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-12-17 : 09:56:56
|
| Thank you very much for your help!I have the following additional questions to ask you which are:1. How can I dynamically change the path in the ssrs report so that the correct path (url) is utilized?2. Can yopu show me the code on how to use Globals!ReportServerURL correctly so I accomplish my goal correctly? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-18 : 07:47:03
|
| 1. use a custom code for that. inside it based on environment return the appropriate value to append and form the full url2. Sorry didnt understand the issue with. just directly call it with expressions like=Globals!ReportServerURL------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssrs 2008 r2 report access pdf help documents