November 26, 2013 at 9:06 pm
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?
November 28, 2013 at 7:00 am
The URL should be the same if the PDF stays in the same location.
November 28, 2013 at 2:27 pm
The pdf will be in a different location since it will be on a different server. One will be on the production server and the other pdf will be on the test server.
November 28, 2013 at 7:54 pm
I normally store this sort of thing in a config table and use a dataset in the report to retrieve the value. The URL used for the action uses the value from that dataset.
Another option would be to use a hidden parameter in the report and set the value to the URL required.
If you need to do it for just the one report, the hidden parameter might be the easiest way to do it. Otherwise, go with the config table option.
November 29, 2013 at 9:52 pm
Can you show me code for using the config file option?
November 30, 2013 at 5:19 pm
Getting the URL from the database would be the best option.
If you cannot achieve that and need something in the Report itself, you can use javascript instead of a URL in the Action.
Something like this to navigate the current window :
="void(window.navigate( '/somelocation/" & Fields!PDFFilename.Value & "'))"
OR something like this to open a popup:
="void(window.open( '/somelocation/" & Fields!PDFFilename.Value & "','Window1','menubar=no,width=400,height=300,toolbar=no'));"
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);December 1, 2013 at 4:16 am
wendy elizabeth (11/29/2013)
Can you show me code for using the config file option?
All you need to do is create a table to store the location of your PDF, add a dataset to your report with a select statement to get the value and then use that field from that dataset in your Action. Not all that complicated, really
December 1, 2013 at 2:30 pm
How will the ssrs 2008 r2 report know what server it is running on? Is there a command to check ip addresses and/or server names? If so, what is the sql and/or ssrs command to accomplish this goal?
December 1, 2013 at 7:22 pm
wendy elizabeth (12/1/2013)
How will the ssrs 2008 r2 report know what server it is running on? Is there a command to check ip addresses and/or server names? If so, what is the sql and/or ssrs command to accomplish this goal?
Your report doesn't need to know what server it is on. The connection that the dataset(s) in your report uses has that information. So, when the report is deploy to a different report server, the report simply connects to a different server to get its data via the connection on the report server.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply