Move Measures to Column Area in code

aecspades

The most confusing part of the FastCube is explaining that they have to drag fields to the area marked "Move Measure Fields Here", and explain to them why their measure fields don't then appear. It is not intuitive that the Measures list count increments without being able to see the list of fields that has already been added. Is there either a property or some way to change the Grid/Slice so that the Measure List is already part of the Column area i.e. how do I, in code, drag the Measures from the filter area to the column area?

aecspades

aecspades wrote: »

The most confusing part of the FastCube is explaining that they have to drag fields to the area marked "Move Measure Fields Here", and explain to them why their measure fields don't then appear. It is not intuitive that the Measures list count increments without being able to see the list of fields that has already been added. Is there either a property or some way to change the Grid/Slice so that the Measure List is already part of the Column area i.e. how do I, in code, drag the Measures from the filter area to the column area?

Actually I think that I figured this out, if anybody is interested. It does seem like this should be the default behavior, but you can add an event handler like this:

  
  // Add event handler so we can move the Measures to the column area when a field is added
  slice.OnAfterAddedSliceFieldToRegion := afterSliceFieldAddedToRegion;

...and then in that event handler, you can move the Measures to the column area (and then remove the even handler so it doesn't happen again):

  if (ARegionOfField = rf_CapFacts) then
  begin
    // Move measure fields to X Axis
    slice.AddFieldTo(sMeasuresFieldName, '', rf_CapXAx);
    // Remove event handler so that this doesn't happen again
    slice.OnAfterAddedSliceFieldToRegion := nil;
  end;

Rosswood

this is very nice post