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