ReportingService2010.SetItemDataSources Method (String, DataSource )

 

Applies To: SQL Server 2016 Preview

Sets the data sources for an item in a report server database or SharePoint library. This method applies to the Report and Model item types.

Namespace:   ReportService2010
Assembly:  ReportService2010 (in ReportService2010.dll)

Syntax

[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemDataSources", 
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapHeaderAttribute("TrustedUserHeaderValue")]
public void SetItemDataSources(
    string ItemPath,
    DataSource[] DataSources
)
public:
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemDataSources", 
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapHeaderAttribute("TrustedUserHeaderValue")]
void SetItemDataSources(
    String^ ItemPath,
    array<DataSource^>^ DataSources
)
[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemDataSources",
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapHeaderAttribute("TrustedUserHeaderValue")>]
member SetItemDataSources : 
        ItemPath:string *
        DataSources:DataSource[] -> unit
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemDataSources",
    RequestNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    ResponseNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)>
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)>
<SoapHeaderAttribute("TrustedUserHeaderValue")>
Public Sub SetItemDataSources (
    ItemPath As String,
    DataSources As DataSource()
)

Parameters

  • ItemPath
    Type: System.String

    The fully qualified URL of the item including the file name and, in SharePoint mode, the extension.

Remarks

The table below shows header and permissions information on this operation.

SOAP Header Usage

(In) TrustedUserHeaderValue

(Out) ServerInfoHeaderValue

Native Mode Required Permissions

Depends on the item type of ItemPath:

For each data source or model in the DataSourcesarray:

SharePoint Mode Required Permissions

EditListItems on ItemPath AND F:Microsoft.SharePoint.SPBasePermissions.ViewListItems on each data source or model in DataSources

When the Item type is a model, the specified value must be a single DataSourceReference that cannot reference a model or have the data source credentials set to Prompt.

If multiple data sources exist on an item, only those data sources that are being changed may be submitted.

When associating an .rsds or .odc file with a report, the DataSourceReference must contain the fully qualified URL with the file name and .rsds or .odc file name extension. For a DataSourceReference for a file name extension other than .rsds or .odc, the error rsWrongItemType is returned.

See Also

ReportingService2010 Class
ReportService2010 Namespace

Return to top