I am having a navigation issue with jump to URLs in reports. When I have a report that supports drilldown if I click the drill down then click a Jump To URL to render the next report I get a second toolbar. If the drill down was never clicked the jump to works fine.
My workaround was to try and create a javascript url to reset the url for the top frame. However, the same url that was working before is now throwing an rsInvalidItemPath error. Any thoughts?
Here is my original Jump To URL expression that was causing the second toolbar to appear on drill down:
=Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true"
Renders as:
http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true
I changed the Jump to URL expression to the following to try and fix the toolbar issue:
=top.location.href='" + Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true" + "'"
Renders as:
BLOCKED SCRIPTtop.location.href='http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true'
This version of Jump to URL causing the rsInvalidPath Exception to be thrown.
Reporting Services Error
The path of the item "/Early Life/Early Life Technician Summary QA,[Chicago North]" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
SQL Server Reporting Services
Thanks in advance,
Adam
You can use POST instead of GET i.e. using a HTML form with hidden fields rather than building up a URL string. This should get you around the 260 character limit.
Check out this article for an example http://blogs.msdn.com/bryanke/articles/73153.aspx
No comments:
Post a Comment