I am trying to implement a reporting server solution by code using the Reporting Server Web Service:
Unfortunately, I can not find any examples online just a few ambiguous information.
When the Business Intelligence publishes through the Development Studio, it publishes the shared data source and then publishes the report. I'm trying something similar on C #:
var service = new ReportingService2010 (); Service.Credentials = New network credentials (username, password, domain); Forex Currency (Data Data Source (GearData Sources)) {String Name = Path. GateFileName Extensions Without Extensions (Datasource Path); Byte [] Content = GetFileContent (dataSourcePath); Service.CreateCatalogItem ("DataSource", name, guardian, true, content, zero, outside warnings); } But CreateCatalogItem gives me the following SoapException exception:
The input XML schema does not correspond XML grammar has been described in the API documentation. For reports in XML, see the Report Definition Language syntax. --- & gt; Microsoft.ReportingServices.Diagnostics.Utilities.InvalidXmlException: does not conform to the input XML schema XML grammar has been described in the API documentation. For XML for the report, see the report definition language syntax.
Is anyone messing up or should I have some other way?
I had the same problem I found the solution is as follows: You are using the wrong datasource file format - like:
& lt ;? Xml version = "1.0" encoding = "UTF-8"? & Gt; & Lt; RptDataSource xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns: xsd = "http://www.w3.org/2001/XMLSchema" name = "datasource sxml" & gt; & Lt; ConnectionProperties & gt; & Lt; Extensions & gt; XML & lt; / Extensions & gt; & Lt; ConnectString & gt; Http: //server/_vti_bin/lists.asmx< / ConnectString & gt; & Lt; IntegratedSecurity & gt; True & lt; / IntegratedSecurity & gt; & Lt; / ConnectionProperties & gt; & Lt; DataSourceID & gt; & Lt; / DataSourceID & gt; & Lt; / RptDataSource & gt; Correct:
& lt ;? Xml version = "1.0" encoding = "UTF-8"? & Gt; & Lt; DataSource Definition xmlns = "http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource" & gt; & Lt; Extensions & gt; XML & lt; / Extensions & gt; & Lt; ConnectString & gt; Http: //server/_vti_bin/lists.asmx< / ConnectString & gt; & Lt; CredentialRetrieval & gt; Prompt for & lt; / CredentialRetrieval & gt; & Lt; WindowsCredentials & gt; This is true & lt; / WindowsCredentials & gt; & Lt; Insert & gt; & Lt; / Sooner & gt; & Lt; Enabled & gt; This is true & lt; / Enable & gt; & Lt; / DataSourceDefinition & gt; You can get this definition by downloading datasource from your reporting server.
Comments
Post a Comment