IEaxDataAreaPivotSlice.InvisibleParam

Syntax

InvisibleParam(ParamId: String): Boolean;

Parameters

ParamId. Parameter identifier.

Description

The InvisibleParam property determines whether the parameter with the specified identifier is hidden.

Comments

If the parameter in this property is set to True, the parameter will be hidden. If the parameter is set to False, it is available for work in the report, to which analytical data area belongs.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier. The report data source has one parameter with integer data type.

Add links to the Express and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Expr: IEaxAnalyzer;
    Slice: IEaxDataAreaPivotSlice;
    Params: IMetabaseObjectParamValues;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Expr := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    // Get analytical data area slice
    Slice := Expr.DataArea.Slices.Item(0) As IEaxDataAreaPivotSlice;
    // Get collection of slice source parameters
    Params := Slice.ParamValues;
    // Set parameter value and hide it from express report
    If Slice.IsParameterized Then
        Params.Item(0).Value := 100;
        Slice.InvisibleParam(Params.Item(0).Id) := True;
    End If;
    (Expr As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, value is set for the slice parameter, and the parameter is hidden from express report.