Reporting Services Navigation - Jump to URL error
June 16th, 2008 — ¥ong¥s
Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork. |
I come across some problems in Reporting Services 2005 in SharePoint integration mode when using Navigation - Jump to URL. Here are some strange behaviors on the problem:
1. The link won’t work if you link to a page/item inside a SharePoint List.
2. The link is OK if you link to invalid page/item in a SharePoint List (invalid item name but valid path)
3. The link is OK if you link to other site like http://www.microsoft.com or http://www.ajaxworkspace.com
I tried googling around but can’t find any solid solution. But I found out that we can use JavaScript as a workaround to solve this issue. Replace your Jump to URL format from:
= “http://servername/sitename/documentlist/pagename.aspx”
With
= “javascript:window.location.href= ‘http://servername/sitename/documentlist/pagename.aspx ‘;”
It works for me!
P/s: Does anybody know where to find the restriction rules for error “Other restrictions apply. (rsInvalidItemPath)” in order to construct a valid URL path for reporting services?
August 17th, 2008 at 10:19 pm
[...] Read the rest of this entry (moved to http://www.bronios.com) » Possibly related posts: (automatically generated)Disable right click on SQL reporting services report in SharePoint 2007On the “Secondary Sources” page . . .how to grow hairHouse Cleaning Posted in SSRS, SharePoint. Tags: Integration mode, Navigation - Jump to URL, Reporting Services. [...]
November 11th, 2008 at 2:50 am
Great post. BTW, how do we do the same for dynamic url generation
Ex:
=”Javascript:Window.Location.Href=’http://huronmoss.microlinkllc.com/Shared Documents/’ & Fields!MatterNumber.Value &’.rdl’;”
This does not seem to work..the result url should be something like this;
‘http://huronmoss.microlinkllc.com/Shared Documents/xyz.rdl
please mail with your suggestions to swetha.sankaran@gmail.com
December 10th, 2008 at 11:19 pm
hi All
i have the same problem and i tried this but it is not working
PROBLEM : i am using reporting services and i integrated with aspx pages and report is drill down report and there is one column in that i had given jump to url for linking purpose and it is working fine in asp.net page and now i have integrated this with share point where i have used Page viewer web part and in that if i click on that url it will now open in new window . plz help me ASAP
Thanks & Regards
Girdhar Jhawar
March 10th, 2009 at 10:23 pm
I am also facing the same issue as Girghar. Kindly let me know in case any solution has been reached. Is there any alternative approach to open the drill through report in a new window with MOSS and SSRS?