--- Grid ---

mzmzmz · January 2013

Hi

1) selecting a prameter to be displayed (compare attached image. please)

I would like to select individual parameters:

'VALUE' or 'P_VALUE' or 'BACKGROUND_VALUE'

to be displayed within the grid. Not interactively, but controlled
by a routine: Values only or P_VALUES only or

2) how to determine, the number of data columns and data rows
of a grid ?

Any ideas ???

Thanx a lot and Greetings, MZ

-=Oleg=- · January 2013

Hi.

1.
Working with measure:

//<ex_HideMeasureAmount
  procedure ex_HideMeasureAmount;
  var AIndex: integer;
  begin
    AIndex := fcSlice.FieldsOfRegion(rf_CapFacts).IndexOf('Measure_1');
    if AIndex >= 0 then
    begin
      fcSlice.CapFactsFieldsAbs[AIndex].VisibleInData := False;
    end
  end;
//ex_HideMeasureAmount>
//<ex_ShowAllMeasures
  procedure ex_ShowAllMeasures;
  var i: integer;
  begin
    for i := 0 to fcSlice.FieldsOfRegion(rf_CapFacts).Count - 1 do
      fcSlice.CapFactsFieldsAbs[i].VisibleInData := True;
  end;
//ex_ShowAllMeasures>
//<ex_AddMeasureCountOfUniqueProducts
  procedure ex_AddMeasureCountOfUniqueProducts;
  begin
    fcSlice.AddFieldTo('CountOfUniqueProducts', 'Product', 'Type Products Count', rf_CapFacts, af_CountOfUnique);
  end;
//ex_AddMeasureCountOfUniqueProducts>

Imortant: fcSlice.FieldsOfRegion(rf_CapFacts).IndexOf - used Name of measure! Not Caption!

2.
column count:
Slice.XAxisVisibleItemCount
row count:
Slice.YAxisVisibleItemCount

Best regards,
Oleg Pryalkov.

--- Grid ---

Comments

Leave a Comment