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-11-26 : 23:02:42
|
| In a new SSRS 2008 r2 report, I am using the 'action' option to point to a url. When the user clicks on the link, a PDF document is displayed. My question deals when the SSRS 2008 R2 report is moved from test report server to a production report server. I would like to know how to use the same https://severname/directory name// *.pdf location while pointing to a different server? is this possible? If so, how would you setup this code? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 05:04:34
|
| for that what you can do is add a custom code to retrieve the current environment info and based on it get correct server name. You can also identify Environment by checking report url by using Globals.ReportServerUrl------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-27 : 09:43:44
|
| The test server url will look like: https://testserver/customer/testq.pdf.The production server will look like https://prodserver/customer/testq.pdf.Thus the location where I have the testserver and prodserver name, is there a way to dynamically change the server name through a parameter or another option? If so, can you show me how to accomplish this goal? |
|
|
|
|
|
|
ssrs 2008 r2 change server name