all groups > sql server reporting services > january 2007 >
You're in the

sql server reporting services

group:

Jump to URL mangling


Jump to URL mangling Sean Carpenter
1/5/2007 3:05:07 PM
sql server reporting services: I am using "Jump to URL" in a few reports to jump to other reports on the
same reporting services instance. The problem I'm having is that when RS
renders the report, it changes the URL to include a prefix of
"http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=".
This is then followed by the actual URL I want to jump to. However, I don't
want this prefix to be applied. It seems to only happen when the
destination of the jump is the reporting server - if I jump to another of
our web servers, the prefix isn't applied.

I am running RS 2000 SP2 on Windows 2000 Advanced Server SP4. Also, the
URLRoot element in RSReportServer.config is set to
"http://reportingserver.domain.com/ReportServer" (DNS name of the server as
opposed to NetBIOS name). Is there a way to prevent this prefix from being
applied?

Thanks,
Sean Carpenter

RE: Jump to URL mangling weilu NO[at]SPAM online.microsoft.com
1/8/2007 6:28:08 AM
Hello Sean,

How about use the full server url in the "Jump to URL" ?

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Re: Jump to URL mangling Sean Carpenter
1/8/2007 10:46:37 AM
I am using the full URL in the Jump to URL expression. For example, a Jump
to URL of:

http://reportingserver.domain.com/ReportServer/?/ReportDirectory/AnotherReport&rs:Command=Render&rs:format=HTML4.0&rc:Parameters=False&rc:ToolBar=True&Year=2006&Month=12&rc:LinkTarget=_main

Gets changed to:

http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2freportingserver.domain.com%2fReportServer%3f%2fReportDirectory%2fAnotherReport%26rs%3aCommand%3dRender%26rs%3aformat%3dHTML4.0%26rc%3aParameters%3dFalse%26rc%3aToolBar%3dTrue%26Year%3d2006%26Month%3d12%26rc%3aLinkTarget%3d_main%26rc%253aReplacementRoot%3dhttp%253a%252f%252freportingserver.domain.com%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d

It looks like the problem only occurs when the destination URL has the same
machine name as the URLRoot element of the RSReportServer.config file. Is
there any way to prevent this from happening?

Sean Carpenter


[quoted text, click to view]

Re: Jump to URL mangling Bruce L-C [MVP]
1/9/2007 10:24:18 AM
Do the following. I think not only does it get around your problem but it
allows you to not hard code any server names:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"

This does csv in ascii format but you can change how you want.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Jump to URL mangling weilu NO[at]SPAM online.microsoft.com
1/12/2007 11:10:36 AM
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button