Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / March 2007

Tip: Looking for answers? Try searching our database.

DrillThrough Report Error: rsInvalidItemPath

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rob - 20 Mar 2007 20:25 GMT
RS 2005 rsInvalidItemPath Error.

I am calling a drillthrough report from the ReportViewer control in a
VS 2005 web application.  My report structure is as follows:

ParentReport (drillthrough)
ChildReport1(drillthrough)
ChildReport2

I can drill from Parent Report to Child1, but when I drill from Child1
to Child2, I get the following error:

The path of the item "(null)" is not valid. The path must be less than
260 characters long and must start with slash. Other restrictions
apply

Stack-Trace:
Microsoft.Reporting.WebForms.ReportServerException: The path of the
item "(null)" is not valid. The path must be less than 260 characters
long and must start with slash. Other restrictions apply.
(rsInvalidItemPath) at
Microsoft.Reporting.WebForms.ServerReport.PerformDrillthrough(String
drillthroughId, String& reportPath) at
Microsoft.Reporting.WebForms.ReportActionHandler.HandleDrillthrough(String
drillthroughID) at
Microsoft.Reporting.WebForms.ReportActionHandler.HandleAction(String
actionType, String actionParam, Int32& currentPage, Boolean&
pageSetByEvent, String& navigationID, String& searchText, Int32&
searchStartPage, String& alertMessage, Report& targetReport) at
Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument)

Report Path: /screensave/screensave
Report URL: http://myserver/reportserver
IsDrillThrough: True

I am passing two parameters.

Any recommendations would be much appreciated.

Thanks.
Rob - 21 Mar 2007 15:29 GMT
> RS 2005 rsInvalidItemPath Error.
>
[quoted text clipped - 37 lines]
>
> Thanks.

Just to add one more thing, when I run this from Report Manager which
is located on the same machine as the Report Server, I do not get this
error.  It must be in the exchange between the reportviewer control on
the web app and the web service on the reportserver.  Does anyone know
how this connection takes place in a drill down scenario?  I assume
that when the web application (with reportviewer control) makes a call
to the web service, it opens the authenticated connection.  Then at
each drill down event, does it make a round trip back to the web app?
It is on the third round trip that I see the error.

Thanks again..
harsh - 30 Mar 2007 08:54 GMT
Hi Rob,

I am getting a similar problem as well. What happens in my case is,
I have a parent report and from it I open the drill down. This works fine as
you pointed out.

I have kept an textbox in the drilled down report which has a hyperlink to
take it back to the parent report. This works fine on the Report server, but
fails on the Web server inside the Report viewer control.

My assumption is that as the viewer opens the page, on subsequent drill
downs, the path keeps on increasing in length and eventually goes above limit.

I will let you know if I find any solution for this. Please keep me posted
as well if you  get any solutions yourself.

Harsh

> > RS 2005 rsInvalidItemPath Error.
> >
[quoted text clipped - 49 lines]
>
> Thanks again..
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.