SSRS 2008, C# and ReportingService.Render()
in [Reports]
|
Prev: Defaulting the (Select All) Parameter SSRS2005 SP2
Next: Error during exporting a report in PDF format (SSRS 2008)
From: Jarppi on 23 Feb 2010 06:02 HI All, We recently upgraded from SQL2005 to SQL2008 and have now run into a problem I can't seem to find a solution for. We have a Windows Service tied to a database with a list of scheduled reports, which basically (at the given time) renders the report and emails it to the person. I know that this is built-in functionality in SSRS Subscriptions but I've inherited this little monster and have instructions not to change the scheduling methodology. So I've created a new web reference to http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in my project, changed the old ReportingService variables to the new type and now I get a message saying: ----------------------------- Error 1 'WindowsService.ReportService2008.ReportingService2005' does not contain a definition for 'Render' and no extension method 'Render' accepting a first argument of type 'WindowsService.ReportService2008.ReportingService2005' could be found (are you missing a using directive or an assembly reference?)...... ----------------------------- Not sure where to go from here, anyone else ever encounter this and managed to solve it? Regards, Jarppi
From: sloan on 23 Feb 2010 16:14 I've only hit one issue going from 2005 to 2008. Which I outline here: http://ssrsmsbuildtasks.codeplex.com/WorkItem/View.aspx?WorkItemId=5323 But I don't think that has anything to do with what you have going on. My suggestion: Go here: http://ssrsmsbuildtasks.codeplex.com/ Get the source code. I would look for clues here: \Web References\MSReportService2005\Reference.cs \Web References\MSReportService2005\ReportService2005.wsdl \Web References\MSReportService2006\Reference.cs \Web References\MSReportService2006\ReportService2006.wsdl That'll give you some wsdl that aren't coming from your machine. ........... I've integrated that codeplex solution into my own projects. (In fact, I've one of the 3-4 people who have made multiple comments and suggestions to the project in the discussions). But it does work pretty well. And I like having a "deploy ssrs reports" framework that other people are using and contributing to. Good luck, I don't know what you issue is. But maybe the above can be useful. "Jarppi" <jarppi.duplessis(a)gmail.com> wrote in message news:31113e32-a98f-4c93-967f-787826f78381(a)f8g2000yqn.googlegroups.com... > HI All, > We recently upgraded from SQL2005 to SQL2008 and have now run into a > problem I can't seem to find a solution for. > > We have a Windows Service tied to a database with a list of scheduled > reports, which basically (at the given time) renders the report and > emails it to the person. I know that this is built-in functionality in > SSRS Subscriptions but I've inherited this little monster and have > instructions not to change the scheduling methodology. > > So I've created a new web reference to > http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in > my project, changed the old ReportingService variables to the new type > and now I get a message saying: > > ----------------------------- > Error 1 'WindowsService.ReportService2008.ReportingService2005' does > not contain a definition for 'Render' and no extension method 'Render' > accepting a first argument of type > 'WindowsService.ReportService2008.ReportingService2005' could be found > (are you missing a using directive or an assembly reference?)...... > ----------------------------- > > Not sure where to go from here, anyone else ever encounter this and > managed to solve it? > > Regards, > Jarppi
From: sloan on 23 Feb 2010 16:20 PS //Quote >> So I've created a new web reference to >> http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in >> my project, //End Quote When I add a reference, I add it like this: http://localhost/ReportServer1/ReportService2005.asmx Note ("ReportServer1" just happens to be what I named mine, for future googler!) .... Where you have the additional "?WSDL" and I don't have it. No idea if that makes a difference. "sloan" <sloan(a)ipass.net> wrote in message news:uojFt0MtKHA.732(a)TK2MSFTNGP06.phx.gbl... > > I've only hit one issue going from 2005 to 2008. > Which I outline here: > http://ssrsmsbuildtasks.codeplex.com/WorkItem/View.aspx?WorkItemId=5323 > > But I don't think that has anything to do with what you have going on. > > My suggestion: > > Go here: > http://ssrsmsbuildtasks.codeplex.com/ > > Get the source code. > > I would look for clues here: > \Web References\MSReportService2005\Reference.cs > \Web References\MSReportService2005\ReportService2005.wsdl > \Web References\MSReportService2006\Reference.cs > \Web References\MSReportService2006\ReportService2006.wsdl > > That'll give you some wsdl that aren't coming from your machine. > > .......... > > I've integrated that codeplex solution into my own projects. (In fact, > I've one of the 3-4 people who have made multiple comments and suggestions > to the project in the discussions). > But it does work pretty well. And I like having a "deploy ssrs reports" > framework that other people are using and contributing to. > > Good luck, I don't know what you issue is. But maybe the above can be > useful. > > > > > > > "Jarppi" <jarppi.duplessis(a)gmail.com> wrote in message > news:31113e32-a98f-4c93-967f-787826f78381(a)f8g2000yqn.googlegroups.com... >> HI All, >> We recently upgraded from SQL2005 to SQL2008 and have now run into a >> problem I can't seem to find a solution for. >> >> We have a Windows Service tied to a database with a list of scheduled >> reports, which basically (at the given time) renders the report and >> emails it to the person. I know that this is built-in functionality in >> SSRS Subscriptions but I've inherited this little monster and have >> instructions not to change the scheduling methodology. >> >> So I've created a new web reference to >> http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in >> my project, changed the old ReportingService variables to the new type >> and now I get a message saying: >> >> ----------------------------- >> Error 1 'WindowsService.ReportService2008.ReportingService2005' does >> not contain a definition for 'Render' and no extension method 'Render' >> accepting a first argument of type >> 'WindowsService.ReportService2008.ReportingService2005' could be found >> (are you missing a using directive or an assembly reference?)...... >> ----------------------------- >> >> Not sure where to go from here, anyone else ever encounter this and >> managed to solve it? >> >> Regards, >> Jarppi > >
From: Alberto Poblacion on 23 Feb 2010 16:27 "Jarppi" <jarppi.duplessis(a)gmail.com> wrote in message news:31113e32-a98f-4c93-967f-787826f78381(a)f8g2000yqn.googlegroups.com... > [...] > So I've created a new web reference to > http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in > my project, changed the old ReportingService variables to the new type > and now I get a message saying: > > ----------------------------- > Error 1 'WindowsService.ReportService2008.ReportingService2005' does > not contain a definition for 'Render' and no extension method 'Render' > accepting a first argument of type > 'WindowsService.ReportService2008.ReportingService2005' could be found > (are you missing a using directive or an assembly reference?)...... > ----------------------------- I believe that you have used a reference to the wrong endpoint. If I recall correctly, the Render method is not in ReportingService2005.asmx, but in ReportExecution2005.asmx
From: sloan on 23 Feb 2010 16:49
Nice memory Alberto! <s:element name="Render"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="Format" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="DeviceInfo" type="s:string" /> </s:sequence> </s:complexType> </s:element> http://localhost/ReportServer1/ReportExecution2005.asmx "Alberto Poblacion" <earthling-quitaestoparacontestar(a)poblacion.org> wrote in message news:%23E5SC8MtKHA.5940(a)TK2MSFTNGP02.phx.gbl... > "Jarppi" <jarppi.duplessis(a)gmail.com> wrote in message > news:31113e32-a98f-4c93-967f-787826f78381(a)f8g2000yqn.googlegroups.com... >> [...] >> So I've created a new web reference to >> http://myreportserver/ReportServer/ReportingService2005.asmx?WSDL in >> my project, changed the old ReportingService variables to the new type >> and now I get a message saying: >> >> ----------------------------- >> Error 1 'WindowsService.ReportService2008.ReportingService2005' does >> not contain a definition for 'Render' and no extension method 'Render' >> accepting a first argument of type >> 'WindowsService.ReportService2008.ReportingService2005' could be found >> (are you missing a using directive or an assembly reference?)...... >> ----------------------------- > > > I believe that you have used a reference to the wrong endpoint. If I > recall correctly, the Render method is not in ReportingService2005.asmx, > but in ReportExecution2005.asmx > > |