I have a vs2010 application where I have defined a reportviewer and I point to an existing report on a server. I am referring to this report as a remote report and I have set up parameters inside the application that I want to pass onto the server report.
When I get to the line that defines the parameters, however, I get the message that ' remote report processing requires microsoft sql server 2008 reporting services or later.. and the exeption details are:
Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection+SoapVersionMismatchException: Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later.
this is the code that I have - am I doing something obviously wrong? I have read a lot about using the reportservice2010.asmx , but I still don't know what's wrong.
It blows up on the line where I am using 'SetParameters'. I also tried using reportservice2005.asmx, but that didn't work either.
I have the reportviewer defined in the designer of my project, is that correct? Or, am I supposed to build a reportviewer on the fly?
I got a little further, but now I am getting this error:s not valid. 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. (rsInvalidItemPath).
I have searched on this error but so far, I haven't been able to resolve this problem. I'm not sure what it really means. Anybody?
Ok, I'm baffled. I removed the reference to reportserver2010.asmx and I can get my report.
this is the code that I have - am I doing something obviously wrong? I have read a lot about using the reportservice2010.asmx , but I still don't know what's wrong.
First of all, if you want to generate a report by using web service, you’d better have a look at
this similar thread. As it mentioned, the ReportExecution2005.asmx should be used to implement this need. The following links provide some demos to show to how to build
the report by using ReportExecution2005.asmx and you could have a look if you need.
I removed the reference to reportserver2010.asmx and I can get my report
All in all, I’m glad to know you have solved your issue and thank you for your sharing. It would be beneficial for other community members who have the similar questions.
maggiemays
Member
38 Points
329 Posts
question about using reportservice2010.asmx
Mar 15, 2016 04:57 PM|maggiemays|LINK
hi,
I have a vs2010 application where I have defined a reportviewer and I point to an existing report on a server. I am referring to this report as a remote report and I have set up parameters inside the application that I want to pass onto the server report. When I get to the line that defines the parameters, however, I get the message that ' remote report processing requires microsoft sql server 2008 reporting services or later.. and the exeption details are: Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection+SoapVersionMismatchException: Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later.
this is the code that I have - am I doing something obviously wrong? I have read a lot about using the reportservice2010.asmx , but I still don't know what's wrong.
serverReport.ReportServerUrl = new Uri("http://rptsrv2/ReportServer/reportservice2010.asmx?"); serverReport.ReportPath = @"/samReports/Rpttester.rdl"; serverReport.ReportPath = "/samReports"; ReportViewer4.ServerReport.SetParameters(new ReportParameter[]{datestart,dateEnd,firstName,lastName});It blows up on the line where I am using 'SetParameters'. I also tried using reportservice2005.asmx, but that didn't work either.
I have the reportviewer defined in the designer of my project, is that correct? Or, am I supposed to build a reportviewer on the fly?
I got a little further, but now I am getting this error:s not valid. 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. (rsInvalidItemPath).
I have searched on this error but so far, I haven't been able to resolve this problem. I'm not sure what it really means. Anybody?
Ok, I'm baffled. I removed the reference to reportserver2010.asmx and I can get my report.
Weibo Zhang
Star
7990 Points
1586 Posts
Re: question about using reportservice2010.asmx
Mar 16, 2016 08:43 AM|Weibo Zhang|LINK
Hi maggiemays,
First of all, if you want to generate a report by using web service, you’d better have a look at this similar thread. As it mentioned, the ReportExecution2005.asmx should be used to implement this need. The following links provide some demos to show to how to build the report by using ReportExecution2005.asmx and you could have a look if you need.
https://support.microsoft.com/en-us/kb/875447
http://blogs.msdn.com/b/selvar/archive/2010/12/13/accessing-the-reportexecutionservice-render-method-when-reporting-service-2008-r2-is-in-forms-based-authentication.aspx
All in all, I’m glad to know you have solved your issue and thank you for your sharing. It would be beneficial for other community members who have the similar questions.
Best Regards,
Weibo Zhang
maggiemays
Member
38 Points
329 Posts
Re: question about using reportservice2010.asmx
Mar 16, 2016 10:31 PM|maggiemays|LINK
Thank you Weibo for the links. I am interested in finding out more about reportService and reportExecution
m.