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

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

Other recent topics Other recent topics