SSRS 2008 reporting service proxy issues
Hi friends,
We are facing the following issues after upgrading web reference to ReportService2010.asmx reporting service.
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
The type or namespace name 'ItemTypeEnum' could not be found (are you missing a using directive or an assembly reference?)
Have any of you faced the same issues while upgrading the service reference? Are there any alternative classes for the same.
One alternative to the error no. 2 has been given in the following link.
http://www.deeptraining.com/litwin/devcnxfall10/Litwin_SQL_SBI305_ProgrammingReportingServices.pdf
But I am not able to find solution for error 1. Please provide your views.
Thanks.
Murtaza
November 25th, 2010 2:38pm
After resolving few issues, more errors are surfacing. The error list is as follows.
The type or namespace name 'ItemTypeEnum' could not be found (are you missing a using directive or an assembly reference?)
The type or namespace name 'ItemTypeEnum' could not be found (are you missing a using directive or an assembly reference?)
CatalogItem' does not contain a definition for 'Type' and no extension method 'Type' accepting a first argument of type 'CatalogItem' could be found (are you missing a using directive or an assembly
reference?)
CatalogItem' does not contain a definition for 'Type' and no extension method 'Type' accepting a first argument of type 'CatalogItem' could be found (are you missing a using directive or an assembly
reference?)
The name 'ItemTypeEnum' does not exist in the current context
The type or namespace name 'ReportHistorySnapshot' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'ListReportHistory' and no extension method 'ListReportHistory' accepting a first argument of type 'ReportingService2010' could be found (are
you missing a using directive or an assembly reference?)
The type or namespace name 'ReportHistorySnapshot' could not be found (are you missing a using directive or an assembly reference?)
The type or namespace name 'ReportHistorySnapshot' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'ListReportHistory' and no extension method 'ListReportHistory' accepting a first argument of type 'ReportingService2010' could be found (are
you missing a using directive or an assembly reference?)
The type or namespace name 'ReportHistorySnapshot' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'DeleteReportHistorySnapshot' and no extension method 'DeleteReportHistorySnapshot' accepting a first argument of type 'ReportingService2010'
could be found (are you missing a using directive or an assembly reference?)
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
Cannot implicitly convert type 'ItemParameter[]' to 'ReportParameter[]'
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
CatalogItem' does not contain a definition for 'Type' and no extension method 'Type' accepting a first argument of type 'CatalogItem' could be found (are you missing a using directive or an assembly
reference?)
The name 'ItemTypeEnum' does not exist in the current context
No overload for method 'ListSubscriptions' takes '2' arguments
No overload for method 'ListSubscriptions' takes '2' arguments
ReportingService2010' does not contain a definition for 'GetReportDefinition' and no extension method 'GetReportDefinition' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'GetReportDefinition' and no extension method 'GetReportDefinition' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
SearchCondition' does not contain a definition for 'Value' and no extension method 'Value' accepting a first argument of type 'SearchCondition' could be found (are you missing a using directive or
an assembly reference?)
No overload for method 'FindItems' takes '3' arguments
ReportingService2010' does not contain a definition for 'CreateReport' and no extension method 'CreateReport' accepting a first argument of type 'ReportingService2010' could be found (are you missing
a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'CreateReport' and no extension method 'CreateReport' accepting a first argument of type 'ReportingService2010' could be found (are you missing
a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'CreateLinkedReport' and no extension method 'CreateLinkedReport' accepting a first argument of type 'ReportingService2010' could be found (are
you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'SetReportHistoryOptions' and no extension method 'SetReportHistoryOptions' accepting a first argument of type 'ReportingService2010' could
be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'SetReportHistoryLimit' and no extension method 'SetReportHistoryLimit' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
Cannot implicitly convert type 'ItemParameter[]' to 'ReportParameter[]'
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'SetReportParameters' and no extension method 'SetReportParameters' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
Cannot implicitly convert type 'ItemParameter[]' to 'ReportParameter[]'
The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'SetReportParameters' and no extension method 'SetReportParameters' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'GetReportParameters' and no extension method 'GetReportParameters' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'CreateReportHistorySnapshot' and no extension method 'CreateReportHistorySnapshot' accepting a first argument of type 'ReportingService2010'
could be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'GetReportDefinition' and no extension method 'GetReportDefinition' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'CreateReport' and no extension method 'CreateReport' accepting a first argument of type 'ReportingService2010' could be found (are you missing
a using directive or an assembly reference?)
The type or namespace name 'ReportHistorySnapshot' could not be found (are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'ListReportHistory' and no extension method 'ListReportHistory' accepting a first argument of type 'ReportingService2010' could be found (are
you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'GetReportDefinition' and no extension method 'GetReportDefinition' accepting a first argument of type 'ReportingService2010' could be found
(are you missing a using directive or an assembly reference?)
ReportingService2010' does not contain a definition for 'GetReportDefinition' and no extension method 'GetReportDefinition' accepting a first argument of type 'ReportingService2010' could be found (are you missing a using directive or an assembly reference?)
Regards,
Murtaza
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 10:12am
Hi Murtaza,
In ReportService2010 proxy class, we use 'ItemParameter' instead of 'ReportParameter'. This means 'ReportParameter' is no longer available in ReportService2010 proxy class.
Also, in ReportService2010 proxy class, we use 'TypeName' to describe a type of a catalogItem. The 'TypeName' will return string name of the type directly. In 2005 proxy class, we use 'ItemTypeEnum' to describe a catalogItem type.
According to the analysis above, the behavior in ReportService2010 proxy class is totally different with ReportService2005 proxy. So, please implement new code using the ReportService2010 proxy class. It is not recommended to upgrade the ReportService2005
web service reference to ReportService2010 web service reference directly.
ReportService2005 proxy class is still available in SQL Server Reporting Services(SSRS) 2008 R2.
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
November 29th, 2010 10:04am
Hi Jin - I have searched everywhere but couldnot find anything directly related to the FindItem's method.
In the FindItem there is one more searchOptions Parameter of type Property and when i am trying to give it a name, it's just don't like it.
even msdn and microsoft articles are a bit vague.
Property searchoptions = new Property();
searchoptions.Value = item.ToString();
searchoptions.Name = "name";
results = rs.FindItems(parent, BooleanOperatorEnum.And, new Property[] {searchoptions}, new SearchCondition[] { search });
Not sure what the problem is but error which I am getting is that Name has invalid value.
any help would be highly appreciated?
Thx in advance.
sandy.
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2011 11:40pm
im trying to get report through ReportServices2010 and render it, but in 2010 service isnt more the method Render, is any workaround for it ?
Also i tried with ReportServices2010SoapClient() ....
July 19th, 2011 9:25am
There are two main type of endpoints in the Report Server web service (http://msdn.microsoft.com/en-us/library/ms155398.aspx) one for Management wich is the one that has multiple
endpoints like ReportService2005, ReportService2006, ReportService2010 and the execution that only has one endpoint ReportExecution2005.
The Render method is part of the execution endpoint, so you need to reference it
http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.aspx
This posting is provided "AS IS" with no warranties, and confers no rights
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 12:28pm