Parameters in URL - Doesn't work (rsInvalidItemPath)
The URL must be like this http://Server/ReportServer/Pages/ReportViewer.aspx?%2fFolder1%2fFolder2%2fReportName&rs:Command=Render Cross check your Url-------------------------------------------------------- Surender Singh Bhadauria My Blog
November 19th, 2011 8:58am

Hello again Surender, I have the following ReportPath working perfectly withou params: http://myServer/ReportServer/ReportFolder/myReport I want to able to add a parameter to this already existing (and working) ReportPath. Why should I use "%2" in ReportPath? I don't have any white spaces... SuperJBJB
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 9:20am

Sorry I missed out on Your Code i thought that you are calling a SSRS report Directly But in your case you are assigning the report to the report viewer my URL was through the Report Viever page Provided by the SSRS Server In your Case you have to use the ReportViewer1.ServerReport.SetParameters(paramList); to pass the parameter Refer http://msdn.microsoft.com/en-us/library/ms252663.aspx -------------------------------------------------------- Surender Singh Bhadauria My Blog
November 19th, 2011 10:26am

Thanks a lot Surender! Finally got it running correctly! SuperJB :)JB
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 11:17am

Hello everyone, I have a webApp (ASP.NET 4.2 with VS2010) that links to my SSRS server (WinServer 2008R2 - SQL Server 2008R2). This works fine when I request a Report WITHOUT parameters... all reports work without a problem (so this is not a problem with my ReportViewer control, ReportViewer.ServerPath, ReportViewer.ServerPath.ReportServerURL, ReportViewer.ServerPath.ReportPath or ReportViewer.ServerPath.ReportServerCredentials)... Sorry about this, but I just wanted to make it clear that this works fine without params. I'm trying to pass a param to a specific Report (ParamName = pLanguage). I've checked, double checked, triple checked and the name is correct. When I hit the link to request my Report, I add this to the end of my ReportViewer.ServerPath.ReportPath: <strong>+ @"&rs:Command=Render&pLanguage=2";</strong> My param "pLanguage is an int and is Hidden and has a DefaultValue=1 for the situations where it's not passed. Like I said before, if I request the report without the param, it works fine. If i add the param to URL, I get a rsInvalidItemPath error. Any help please?! Thanks in advance, SuperJBJB
November 20th, 2011 5:38am

Please post Both The URL's Without parameter With Parameter -------------------------------------------------------- Surender Singh Bhadauria My Blog
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 6:17am

Hello Surender, Without parameter (WORKING): http://myServer/ReportServer/ReportFolder/myReport With parameter (NOT WORKING): http://myServer/ReportServer/ReportFolder/myReport&rs:Command=Render&pLanguage=2 All I do in this case, is create the report URL like I did in the first case, and then add the parameter information at the end: "&rs:Command=Render&pLanguage=2"; Any clue on what I may be doing wrong? The parameter "pLanguage" is hidden and I want it to stay hidden. Can it be because of this? SuperJBJB
November 20th, 2011 6:28am

Hello Surender, Without parameter (WORKING): http://myServer/ReportServer/ReportFolder/myReport With parameter (NOT WORKING): http://myServer/ReportServer/ReportFolder/myReport&rs:Command=Render&pLanguage=2 All I do in this case, is create the report URL like I did in the first case, and then add the parameter information at the end: "&rs:Command=Render&pLanguage=2"; Any clue on what I may be doing wrong? The parameter "pLanguage" is hidden and I want it to stay hidden. Can it be because of this? SuperJB JB Try this, http://myServer/ReportServer/ReportFolder/myReport&rs:Command=Render&rc:Parameters=false&pLanguage=2 With Warm Wishes, Dhanalakshmi Chinnakani.
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 6:59am

Hello Dhanalakshmi, Thanks for the feedback, but I get exactlly the same error. And I can't pass rc:Parameters=false because there are other parameters that I need to add to this report (but are user inputs). SuperJBJB
November 20th, 2011 7:13am

To anyone reading this... the error I get is: "The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash" ReportViewer1.ProcessingMode = ProcessingMode.Remote; ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://myServer/ReportServer"); ReportViewer1.ServerReport.ReportPath = @"/AdventureWorks/myReport"; <strong>if(params == true) ReportViewer1.ServerReport.ReportPath += @"&rsCommand=Render&pLanguage=4"; </strong>ReportViewer1.DataBind(); If I run the WepApp and skip the IF clause, it works fine and shows the Report. If I run the WebApp but enter the IF clause, I get the error I've mentioned before. And NO, full path is not more than 260 characters! Any help please?! SuperJBJB
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 8:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics