SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ssrs 2008 r2 c hange server name location


ssrs 2008 r2 c hange server name location

Author
Message
wendy elizabeth
wendy elizabeth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1253 Visits: 775
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?
Steven.Howes
Steven.Howes
SSC Eights!
SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)

Group: General Forum Members
Points: 886 Visits: 2346
The URL should be the same if the PDF stays in the same location.
wendy elizabeth
wendy elizabeth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1253 Visits: 775
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.
happycat59
happycat59
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4801 Visits: 3227
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.



wendy elizabeth
wendy elizabeth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1253 Visits: 775
Can you show me code for using the config file option?
mister.magoo
mister.magoo
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4196 Visits: 7865
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);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • happycat59
    happycat59
    SSCarpal Tunnel
    SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

    Group: General Forum Members
    Points: 4801 Visits: 3227
    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



    wendy elizabeth
    wendy elizabeth
    Ten Centuries
    Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

    Group: General Forum Members
    Points: 1253 Visits: 775
    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?
    happycat59
    happycat59
    SSCarpal Tunnel
    SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

    Group: General Forum Members
    Points: 4801 Visits: 3227
    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.



    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search