Reporting Services Navigation - Jump to URL error

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?

Posted in SSRS, SharePoint.

2 Responses to “Reporting Services Navigation - Jump to URL error”

  1. Reporting Services Navigation - Jump to URL error « yyTech Blog on .Net, SQL, SharePoint, Collaboration and tech tips. Says:

    [...] 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. [...]

  2. Swetha Says:

    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

Leave a Reply