all groups > sql server reporting services > august 2006 >
You're in the

sql server reporting services

group:

Jump-To-Report Links In Exported Reports



Jump-To-Report Links In Exported Reports mt
8/15/2006 12:18:01 PM
sql server reporting services: Know It Alls,
In RS 2K5, whenever a user exports a report containing links to other
reports into Excel, the links are changed from
http://<servername>/reportserver/etc to http://localhost/ReportServer?etc.
Obviously, this renders the link useless unless you happen to be running a
report on the actual server. I have been unable to find any workarounds for
this. Any idears?
Thanks,
MT
Re: Jump-To-Report Links In Exported Reports mt
8/15/2006 1:31:01 PM
Right you are....We are not using the default port which introduced a few
wrinkles. The fix:

http://msdn2.microsoft.com/en-us/library/ms159261.aspx

Using a Custom Port Number
To configure the report server or Report Manager to use a port other than
port 80, you must edit the configuration files.

Open RSReportServer.config in a text editor.

Append the port number to the UrlRoot setting in the rsreportserver.config
file. For example, if Urlroot is set to http://sales01/report server, set it
to http://sales01:8080/reportserver instead.

Open RSWebApplication.config in a text editor.

Set ReportServerUrlto the same URL you specified in UrlRoot.

Delete the value (but not the tags) for ReportServerVirtualDirectory.

Save both files.



Thanks for your help.


[quoted text, click to view]
Re: Jump-To-Report Links In Exported Reports Bruce L-C [MVP]
8/15/2006 2:24:22 PM
Must be a configuration difference with your server. That is not what
happens for me. The links are there and good.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

AddThis Social Bookmark Button