• Article

ReportingService2010.SetItemDataSources Method

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

'Declaration
<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() _
)
'Usage
Dim instance As ReportingService2010
Dim ItemPath As String
Dim DataSources As DataSource()

instance.SetItemDataSources(ItemPath, _
    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")]
public void SetItemDataSources(
    string ItemPath,
    DataSource[] DataSources
)

[SoapDocumentMethodAttribute(L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemDataSources", RequestNamespace = L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    ResponseNamespace = L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapHeaderAttribute(L"TrustedUserHeaderValue")]
public:
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 

public function SetItemDataSources(
    ItemPath : String, 
    DataSources : 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 DataSources array:

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.