Jump to URL generates a rubbish url.

• Tim Pain

  Ten Centuries

  Points: 1136

  More actions

  March 23, 2007 at 10:00 am

  #177262

  Hi,

  I have a Jump to URL that works fine on my pc, but generates a rubbish URL when uploaded and run from the server.

  Both machines are running SQL 2000 and RS SP2.

  On the pc I'm getting this url /ReportServer/?%2fSales+Order&rs:Command=Render&FromOrderID=32153&ToOrderID=32153&OrderType=1&rs:Command=Render&rc:Toolbar=False&rc:LinkTarget=_blank">http://<my pc>/ReportServer/?%2fSales+Order&rs:Command=Render&FromOrderID=32153&ToOrderID=32153&OrderType=1&rs:Command=Render&rc:Toolbar=False&rc:LinkTarget=_blank which works just fine.

  But on the server this get turned into /Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2%2fReportServer%2f%3f%252fSales%2bOrder%26rs%3aCommand%3dRender%26FromOrderID%3d36924%26ToOrderID%3d36924%26OrderType%3d1%26rs%3aCommand%3dRender%26rc%3aToolbar%3dFalse%26rc%3aLinkTarget%3d_blank%26rc%253aReplacementRoot%3dhttp%253a%252f%252fhfserver%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d">http://<my server>/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2<my server>%2fReportServer%2f%3f%252fSales%2bOrder%26rs%3aCommand%3dRender%26FromOrderID%3d36924%26ToOrderID%3d36924%26OrderType%3d1%26rs%3aCommand%3dRender%26rc%3aToolbar%3dFalse%26rc%3aLinkTarget%3d_blank%26rc%253aReplacementRoot%3dhttp%253a%252f%252fhfserver%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d

  Any ideas why the server is producing the addition rubbish please?

  Many thanks

  
  Tim

• Lisa Slater Nicholls

  Hall of Fame

  Points: 3455

  More actions

  March 24, 2007 at 9:23 am

  #696751

  What version of IIS and what OS are you running?

  Also, any chance you are accessing the server via a VPN that could be doing the rewriting?

  >L<

• Tim Pain

  Ten Centuries

  Points: 1136

  More actions

  March 24, 2007 at 11:01 am

  #696757

  On the pc - Win XP SP2, with IIS v5.1

  On the server - SBS (Small Business Server) 2003, with IIS v6.0.

  Maybe, I'm using Remote Desktop to connect to the server, but I'm told the same problem exists for those users directly connected on the same LAN.

  Thanks

  
  Tim

• Tim Pain

  Ten Centuries

  Points: 1136

  More actions

  March 26, 2007 at 7:57 am

  #696871

  Problem solved, although I'm not sure why!

  I was building the full URL ie: <A href="http:///ReportServer/">http://<server>/ReportServer/<report name etc;>, but if you leave off the <A href="http:///ReportServer">http://<server>/ReportServer prefix, SSRS will generate a URL with the necessary prefix.

  It still looks like a partially rubish URL, but at least it works.

  I'm also not clear if this is a Win XP "vs" Win 2003, or an IIS 5 "vs" IIS 6 issue, or maybe a combination.

  
  Tim