ReportExecutionService.SetExecutionParameters2 Method

Sets and validates parameter values associated with the current report execution.

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

Syntax

'Declaration
<SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetExecutionParameters2", RequestNamespace := "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    ResponseNamespace := "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _
<SoapHeaderAttribute("TrustedUserHeaderValue")> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
<SoapHeaderAttribute("ExecutionHeaderValue")> _
Public Function SetExecutionParameters2 ( _
    Parameters As ParameterValue(), _
    ParameterLanguage As String _
) As ExecutionInfo2
'Usage
Dim instance As ReportExecutionService
Dim Parameters As ParameterValue()
Dim ParameterLanguage As String
Dim returnValue As ExecutionInfo2

returnValue = instance.SetExecutionParameters2(Parameters, _
    ParameterLanguage)
[SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetExecutionParameters2", RequestNamespace = "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
[SoapHeaderAttribute("TrustedUserHeaderValue")]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapHeaderAttribute("ExecutionHeaderValue")]
public ExecutionInfo2 SetExecutionParameters2(
    ParameterValue[] Parameters,
    string ParameterLanguage
)
[SoapDocumentMethodAttribute(L"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetExecutionParameters2", RequestNamespace = L"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = L"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
[SoapHeaderAttribute(L"TrustedUserHeaderValue")]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapHeaderAttribute(L"ExecutionHeaderValue")]
public:
ExecutionInfo2^ SetExecutionParameters2(
    array<ParameterValue^>^ Parameters, 
    String^ ParameterLanguage
)
[<SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/SetExecutionParameters2", RequestNamespace = "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
[<SoapHeaderAttribute("TrustedUserHeaderValue")>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapHeaderAttribute("ExecutionHeaderValue")>]
member SetExecutionParameters2 : 
        Parameters:ParameterValue[] * 
        ParameterLanguage:string -> ExecutionInfo2 
public function SetExecutionParameters2(
    Parameters : ParameterValue[], 
    ParameterLanguage : String
) : ExecutionInfo2

Parameters

  • ParameterLanguage
    Type: System.String
    A .NET Framework locale identifier.

Return Value

Type: ReportExecution2005.ExecutionInfo2
An ExecutionInfo2 object containing the new execution.

Remarks

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

SOAP Header Usage

(In) TrustedUserHeaderValue

(In) ExecutionHeaderValue

(Out) ServerInfoHeaderValue

Native Mode Required Permissions

On the main report and all subreports: ReadProperties AND ExecuteAndView

SharePoint Mode Required Permissions

On the main report and all subreports: ViewListItems()

If a snapshot exists in the current execution when the parameter values used in the query are set, it will be cleared (if it is not an execution or a history snapshot). Setting non-query parameters will not cause the snapshot to be cleared, but will require processing before it can be rendered.

If parameters do not pass the validation, then the method will return an error and the parameter values will not be changed.

If ParameterLanguage is specified, parameters are interpreted in this language. If ParameterLanguage is not specified, the default behavior is used.

You cannot specify parameters for execution or history snapshots.