SSRS 2008, C# and ReportingService.Render()

  • Thread starter Thread starter Jarppi
  • Start date Start date
J

Jarppi

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
 
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 said:
[...]
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?)......
-----------------------------
Click to expand...


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
 
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 said:
Jarppi said:
[...]
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?)......
-----------------------------
Click to expand...


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
Click to expand...
 
Back
Top