From: Jarppi on
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

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
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
"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

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
>
>