Editing RDL programatically using C#

re: Editing RDL programatically using C#

Daniel Meresa — Fri, 14 Nov 2008 03:29:48 GMT

I got the following error:

Exception occured: System.Web.Services.Protocols.SoapException: Server did not r

ecognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlse

rver/2005/06/30/reporting/reportingservices/ListChildren.

at System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()

at System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMe

ssage message)

at System.Web.Services.Protocols.SoapServerProtocol.Initialize()

at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, Http

Context context, HttpRequest request, HttpResponse response, Boolean& abortProce

ssing)

any idea?

re: Editing RDL programatically using C#

Dan — Fri, 01 May 2009 20:55:38 GMT

I came across your post while searching for a solution to a related task - in a sharepoint site defintion I upload several "Report Builder Report" files to a reports library (RDL files). However simply uploading them doesn't do the "Report Server" tasks. I'm a newbie to reporting services so my semantics are probably off - if I open the rdl file in the sql server business intelligience studio and manually deploy it to sharepoint, it gets added to the sharepoint library and the "Report Server" tasks are performed. I've been hitting a brick wall trying to figure out how to get the "Report Server" tasks done through code. After reading your post it seems maybe the ReportService2005.asmx web service might provide the answer. Do you think it is possible, and can you offer any pointers or references that would assist in getting me started? thanks

re: Editing RDL programatically using C#

selvar — Thu, 07 May 2009 21:16:54 GMT

You've mentioned about uploading RDL files to Reports Library. How are you doing that? You want it to do that programmatically? To do that programmatically, in Sharepoint integration mode, ReportService2005.asmx web service will not help. You need to use ReportService2006.asmx web service, which is specifically designed to take care of all the operations in the Sharepoint integration mode.

Here are the properties and methods exposed by the reportingservice2006 class built within reportservice2006 namespace.

http://msdn.microsoft.com/en-us/library/reportservice2006.reportingservice2006_members.aspx

This documentation,

http://msdn.microsoft.com/en-us/library/reportservice2006.reportingservice2006.createreport.aspx

will show you how to upload a report programmatically to report server which is in Sharepoint integration mode.

re: Editing RDL programatically using C#

VishalM — Tue, 19 May 2009 14:57:21 GMT

Hello selvar,

I am working on a requirment in which I have to save the snapshot history of .rdl on some local folder. But after restoring the save rdl it is not retaining the history of that report definition.

I am using Reporting Services 2005 and using ReportingServices2005.asmx to fetch and save the report definition.

Thanks and Regards

re: Editing RDL programatically using C#

selvar — Sun, 30 Aug 2009 22:46:37 GMT

Your question is not very clear. But the moment you say you're restoring the RDL, how exactly you're doing? Are you calling CreateReportDefinition? This will actually over write the existing RDL which effectively means anything associated with that RDL will be lost. You need to use SetReportDefinition to retain anything associated with your report. This will actually update the RDL and not over write.