Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 r2 c hange server name location Expand / Collapse
Author
Message
Posted Tuesday, November 26, 2013 9:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:07 PM
Points: 375, Visits: 441
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?
Post #1517884
Posted Thursday, November 28, 2013 7:00 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 586, Visits: 2,100
The URL should be the same if the PDF stays in the same location.
Post #1518350
Posted Thursday, November 28, 2013 2:27 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:07 PM
Points: 375, Visits: 441
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.
Post #1518410
Posted Thursday, November 28, 2013 7:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:00 AM
Points: 2,993, Visits: 2,590
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.



Post #1518431
Posted Friday, November 29, 2013 9:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:07 PM
Points: 375, Visits: 441
Can you show me code for using the config file option?
Post #1518616
Posted Saturday, November 30, 2013 5:19 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:54 AM
Points: 1,778, Visits: 5,729
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


  • MMGrid Addin
  • MMNose Addin


  • 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

  • Post #1518667
    Posted Sunday, December 1, 2013 4:16 AM
    SSCrazy

    SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

    Group: General Forum Members
    Last Login: 2 days ago @ 1:00 AM
    Points: 2,993, Visits: 2,590
    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



    Post #1518691
    Posted Sunday, December 1, 2013 2:30 PM
    Old Hand

    Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

    Group: General Forum Members
    Last Login: Yesterday @ 12:07 PM
    Points: 375, Visits: 441
    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?
    Post #1518712
    Posted Sunday, December 1, 2013 7:22 PM
    SSCrazy

    SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

    Group: General Forum Members
    Last Login: 2 days ago @ 1:00 AM
    Points: 2,993, Visits: 2,590
    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.



    Post #1518743
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse