IEaxGrid.SparklinesPosition

Fore Syntax

SparklinesPosition: EaxSparklinesPosition;

Fore.NET Syntax

SparklinesPosition: Prognoz.Platform.Interop.Express.EaxSparklinesPosition;

Description

The SparklinesPosition property determines a plot area for sparklines in the table.

Comments

Sparklines - small charts displaying data for one series only. Sparklines are built in as a separate row or column and are plotted by the data located in the row or column. If a table displays sparklines by rows or columns, and totals by rows and/or columns, sparklines for totals can be displayed in the table.

Fore Example

Executing the example requires that the repository contains an express report with the EXPR_SLP_GRID identifier with a data table, for which totals by column can be displayed.

Add links to the Express, Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Grid: IEaxGrid;
Begin
    // Get current repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPR_SLP_GRID").Edit As IEaxAnalyzer;
    // Get express report table
    Grid := Express.Grid;
    // Determine displaying of sparklines by rows and for totals
    Grid.SparklinesPosition := EaxSparklinesPosition.Rows Or EaxSparklinesPosition.Totals;
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the express report table displays sparklines by rows and for totals.

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Express;

…

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Grid: IEaxGrid;
Begin
    // Get current repository
    MB := Params.Metabase;
    // Get express report
    Express := MB.ItemById["EXPR_SLP_GRID"].Edit() As IEaxAnalyzer;
    // Get express report table
    Grid := Express.Grid;
    // Determine displaying of sparklines by rows and for totals
    Grid.SparklinesPosition := EaxSparklinesPosition.espRows Or EaxSparklinesPosition.espTotals;
    (Express As IMetabaseObject).Save();
End Sub;