ReportingService2010.SetModelDrillthroughReports Method

Associates a set of drillthrough reports together with a model.

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

Syntax

'Declaration
<SoapHeaderAttribute("TrustedUserHeaderValue")> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetModelDrillthroughReports", 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)> _
Public Sub SetModelDrillthroughReports ( _
    Model As String, _
    ModelItemID As String, _
    Reports As ModelDrillthroughReport() _
)
'Usage
Dim instance As ReportingService2010 
Dim Model As String 
Dim ModelItemID As String 
Dim Reports As ModelDrillthroughReport()

instance.SetModelDrillthroughReports(Model, _
    ModelItemID, Reports)
[SoapHeaderAttribute("TrustedUserHeaderValue")]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetModelDrillthroughReports", 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)]
public void SetModelDrillthroughReports(
    string Model,
    string ModelItemID,
    ModelDrillthroughReport[] Reports
)
[SoapHeaderAttribute(L"TrustedUserHeaderValue")]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapDocumentMethodAttribute(L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetModelDrillthroughReports", 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)]
public:
void SetModelDrillthroughReports(
    String^ Model, 
    String^ ModelItemID, 
    array<ModelDrillthroughReport^>^ Reports
)
[<SoapHeaderAttribute("TrustedUserHeaderValue")>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetModelDrillthroughReports", 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)>]
member SetModelDrillthroughReports : 
        Model:string * 
        ModelItemID:string * 
        Reports:ModelDrillthroughReport[] -> unit
public function SetModelDrillthroughReports(
    Model : String, 
    ModelItemID : String, 
    Reports : ModelDrillthroughReport[]
)

Parameters

  • Model
    Type: System.String
    The fully qualified URL of the model including the file name and .smdl file name extension.
  • ModelItemID
    Type: System.String
    The ID of the model item in the model for which to set model drillthrough reports

Remarks

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

SOAP Header Usage

(In) TrustedUserHeaderValue

(Out) ServerInfoHeaderValue

Native Mode Required Permissions

UpdateContent on Model AND ReadProperties on each report in Reports

SharePoint Mode Required Permissions

ViewListItems on Model AND F[:Microsoft.SharePoint.SPBasePermissions.ViewListItems] on each report in Reports

If there are no drillthrough reports defined, the user will be directed to a dynamically generated clickthrough report.

Drillthrough reports can be single-instance or multiple instance. , You can set one of each type of ModelDrillthroughReport for a model item. You specify the type of the model drillthrough report by setting the Type property of the ModelDrillthroughReport object to a valid DrillthroughType enumerator value of Detail for single-instance or List.

When SetModelDrillthroughReports is called, the previous model drillthrough reports are replaced with the supplied set of drillthrough reports.

To remove a specific model drillthrough report, omit its entry from Reports when you call the SetModelDrillthroughReports method.

You can supply an empty value for the Reports parameter to remove all model drillthrough reports for this entity.

See Also

Reference

ReportingService2010 Class

ReportService2010 Namespace