rsInvalidItemPath Error and Jump to URL Issues

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

Did you get this problem fixed, Adam? I have a similar problem it sounds like where I have a record containing an "&" but SRS is trying to read it as two parameters instead of one, so I get the same 260 characters long error.|||

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

rsInvalidItemPath Error and Jump to URL Issues

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

Did you get this problem fixed, Adam? I have a similar problem it sounds like where I have a record containing an "&" but SRS is trying to read it as two parameters instead of one, so I get the same 260 characters long error.|||

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

sql

rsInternalError on Reporting Services

hello,
i have created a webform to call the reports in the report
server. When i click submit in the webform, it will redirect to the
selected report.
This works fine for the first few times. However, after sometime
i would be getting the following error :
"An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were
in use and max pool size was reached. "
Once this happen, i could not even open my local report server
in the browser.
Could some one please help me......... it's urgent.. thanks
...
--
Message posted via http://www.sqlmonster.comtry setting the timeout to infinite,
rs.Timeout = -1

RS2005: Navigation to NEW Browser Window

Hello,
we want a new browser window to open if we click on a report element with a
hyperlink-action. A second report should be displayed in the new browser
window at the same time. Is this possible?
Regards,
RalphIn the field you want to link, go to the action property. Select jump
to URL and enter an expression like the following:
="javascript:void(window.open('http://www.google.com','_blank'))"
Where the http://www.google.com is where you should put the link to
your report. If you have parameters, you will have to modify the query
string to include the parameters & their values (by programatically
concatenating them).
If you do a search through these forums for "javascript new window"
(without quotes) you should get many samples on how to accomplish some
of this.
Good Luck.
Regards,
Dan

rs:ClearSession not working

the report data does not refresh even though i added the rs:ClearSession parameter to the URL..i have to click the refresh button to get the latest data..

the URL i use:

http://localhost/Alcon/Reports.aspx?rs:ClearSession=true&distCd=DPI&SOSummary=true

any ideas on how to solve this problem?

What is Reports.aspx? Is that your custom application?|||

yes, thr Reports.aspx is the pageviewer actually..

i already solve the problem... but the solution was a bit weird... i have to add the rs:ClearSession to the parameter of the report and not on the URL.

RS Web Part Scrolling

I have installed 4 RS Viewer Web Parts on a share point page. When I
click on the + sign to expand the detail of a report the detail area
scrolls to the top of the sharepoint page. If all four web parts were
viewable and you were on the 2nd one down from the top, the first one
completely disappears. The only way to see it is to use the scroll bar
to move to the top of the page again. This behavior only happens with
RS Web Parts. This is very anoying as you must find your place on the
page everytime you click on a + or - sign. The page is always jumping
around.
Does anybody know how to stop this?Hi
It would be great if anyone can responde to this question since I'm having
the same problem. My end users are getting so anoyed that they have no
interest in using any drill-down reports. As soon as a report is anything
other than a very basic report with only one or two grouping levels,
drill-down functionality is useless.
This is very bad for those of us that recommended SQL RS to our
organizations as an enterprise reporting solution.
Can someone please help us with this?
"Jiles" wrote:
> I have installed 4 RS Viewer Web Parts on a share point page. When I
> click on the + sign to expand the detail of a report the detail area
> scrolls to the top of the sharepoint page. If all four web parts were
> viewable and you were on the 2nd one down from the top, the first one
> completely disappears. The only way to see it is to use the scroll bar
> to move to the top of the page again. This behavior only happens with
> RS Web Parts. This is very anoying as you must find your place on the
> page everytime you click on a + or - sign. The page is always jumping
> around.
> Does anybody know how to stop this?
>