• Article

ReportingService2005.SetItemDataSources Method

Sets the data sources for an item in the catalog.

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

Syntax

'Declaration
<SoapHeaderAttribute("BatchHeaderValue")> _
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetItemDataSources", RequestNamespace := "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    ResponseNamespace := "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
Public Sub SetItemDataSources ( _
    Item As String, _
    DataSources As DataSource() _
)
'Usage
Dim instance As ReportingService2005
Dim Item As String
Dim DataSources As DataSource()

instance.SetItemDataSources(Item, DataSources)

[SoapHeaderAttribute("BatchHeaderValue")]
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetItemDataSources", RequestNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
public void SetItemDataSources(
    string Item,
    DataSource[] DataSources
)

[SoapHeaderAttribute(L"BatchHeaderValue")]
[SoapDocumentMethodAttribute(L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetItemDataSources", RequestNamespace = L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
public:
void SetItemDataSources(
    String^ Item, 
    array<DataSource^>^ DataSources
)

[<SoapHeaderAttribute("BatchHeaderValue")>]
[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetItemDataSources", RequestNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
member SetItemDataSources : 
        Item:string * 
        DataSources:DataSource[] -> unit 

public function SetItemDataSources(
    Item : String, 
    DataSources : DataSource[]
)

Parameters

  • Item
    Type: System.String
    The full name of the item for which to set the data sources. Accepts an EditSessionID generated by the CreateReportEditSession(String, String, array<Byte[]) method.

Remarks

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

SOAP Headers

(In) BatchHeaderValue

(Out) ServerInfoHeaderValue

Required Permissions

Depends on the item type of Item:

SetItemDataSources returns an error when data source properties are set on a linked report item type.

An rsDataSourceNotFound error is returned if a data source that is not associated with the item is passed into the method.

When the Item type is a model, the specified value must be a single DataSourceReference. In this situation, if you supply an array of DataSource objects, an error is returned.

When the type of Item specified is a model, the DataSourceReference specified cannot reference a model or have 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.