PivotChart

Properties:

Attributes
BackColor
Border
BorderColor
DataSource
FieldAreasBackColor
FieldAreasTextColor
FieldAreasTransparent
Fields
Gradient
HorizontalScaleKeeping
HorizontalScaleValueCount
HorizontalScaleValueMinWidth
LabelDelimiter
LabelLocation
LabelTextColor
LabelType
LegendArea
Light
Outline
PercentLabelFormat
PivotChartType
PlotArea
Points
PointsValuesShowMode
Resources
Series
SeriesValuesShowMode
ShowFields
ShowLegend
ShowTitle
SpaceMode
TitleArea
Transparent
ValueLabelFormat

Methods:

GetPicture
Refresh

Events:

DetailProcessing
Selection

Constructors:

Default

Description:

Used to access pivot chart properties, methods and events in general.

Availability:

Server, thick client, external connection.
Serializable. The given object may be serialized to/from XDTO. The XDTO type correspoding to this object is defined in {http://v8.1c.ru/8.2/data/chart} namespace. XDTO type name: PivotChart.

Example:

// Initialization
// Query text in the Report Builder
ReportBuilder.Text = 
"SELECT
... 
|"
;
ReportBuilder.FillSettings();
ReportBuilder.DetailFillType = 
    ReportBuilderDetailsFillType.GroupValues;
ReportBuilder.HeaderText = "Report";

// Receive data
ReportBuilder.Execute();

// Output data
Controls.PivotChart.HorizontalScaleKeeping = 
    PivotChartScaleKeeping.ValueCount;
Controls.PivotChart.HorizontalScaleValueCount = 6;
Controls.PivotChart.PointsValuesShowMode = 
    PivotChartValuesShowMode.LastLevelValues;
Controls.PivotChart.SeriesValuesShowMode = 
    PivotChartValuesShowMode.LastLevelValues;
Controls.PivotChart.DataSource = ReportBuilder;


    

1C:Enterprise Developer's Community